Prev: Sorting and Grouping
Next: How to reference main report field in subreport calculation
From: Stuart on 20 Apr 2010 09:39
Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My problem
is that I cannot get them on one report. And finally I want to DATE Entered
query.
From: Al Campagna on 20 Apr 2010 10:31
Stuart,
What is your table structure/s for the three forms.
One table? Three tables?
Please give us some detail about the important fields in your table/s

What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Stuart" <Stuart(a)discussions.microsoft.com> wrote in message
news:5E817937-C066-4BA0-9634-C279C5D3F946(a)microsoft.com...
> Hi All,
> My problem is that I have 3 Accounting forms:
> 1. Sales
> 2. Expenses
> 3. Purchase Orders
>
> I now want to extract certain fields into one Tax Return Report. The
> fields
> will be to 1. Sales.Total Cost
> 2. Sales. Tax
> 3. Expense. Total Cost
> 4. Expense. Tax
> 5. Purchase Order. Total Cost
> 6. Purchase Order. Tax
>
> Once all these are on the report I can then caluculate as I need, My
> problem
> is that I cannot get them on one report. And finally I want to DATE
> Entered
> query.


From: Duane Hookom on 20 Apr 2010 10:50
I expect you want to create a union query like:
SELECT "Sales" as List, [Total Cost], [Tax]
FROM Sales
UNION ALL
SELECT "Expense", [Total Cost], [Tax]
FROM Expense
UNION ALL
SELECT "Purchases", [Total Cost], [Tax]
FROM [Purchase Order];

You haven't provided enough information about the DATE Entered to even guess
at what you mean.

--
Duane Hookom
Microsoft Access MVP


"Stuart" wrote:

> Hi All,
> My problem is that I have 3 Accounting forms:
> 1. Sales
> 2. Expenses
> 3. Purchase Orders
>
> I now want to extract certain fields into one Tax Return Report. The fields
> will be to 1. Sales.Total Cost
> 2. Sales. Tax
> 3. Expense. Total Cost
> 4. Expense. Tax
> 5. Purchase Order. Total Cost
> 6. Purchase Order. Tax
>
> Once all these are on the report I can then caluculate as I need, My problem
> is that I cannot get them on one report. And finally I want to DATE Entered
> query.
From: Stuart on 26 Apr 2010 05:06
Thanks for the response, I have 3 tables that collect information on:
1. Sales.
2. Purchase Orders.
3. Expenses.

As these forms are seperate and each entery is DATE Entered specific I now
need to extract the information from each form and place them into one report
that queries each form DATE ENTERED Specific. This may cause me problems I
don't know.
After I exstract the information into the report I want to then calculate
Sales totals, Purchase Order Totals and Expenses to get TAX total.

Hope this helps you.
Cheers in advance. Stu

"Al Campagna" wrote:

> Stuart,
> What is your table structure/s for the three forms.
> One table? Three tables?
> Please give us some detail about the important fields in your table/s
>
> What is the logical association between the 3 forms?
> Does a particular Store have Sales, Expenses, POs?
> Or... does an Region have Sales, Expenses, POs?
> --
> hth
> Al Campagna
> Microsoft Access MVP 2007-2009
> http://home.comcast.net/~cccsolutions/index.html
>
> "Find a job that you love... and you'll never work a day in your life."
>
> "Stuart" <Stuart(a)discussions.microsoft.com> wrote in message
> news:5E817937-C066-4BA0-9634-C279C5D3F946(a)microsoft.com...
> > Hi All,
> > My problem is that I have 3 Accounting forms:
> > 1. Sales
> > 2. Expenses
> > 3. Purchase Orders
> >
> > I now want to extract certain fields into one Tax Return Report. The
> > fields
> > will be to 1. Sales.Total Cost
> > 2. Sales. Tax
> > 3. Expense. Total Cost
> > 4. Expense. Tax
> > 5. Purchase Order. Total Cost
> > 6. Purchase Order. Tax
> >
> > Once all these are on the report I can then caluculate as I need, My
> > problem
> > is that I cannot get them on one report. And finally I want to DATE
> > Entered
> > query.
>
>
> .
>
From: Duane Hookom on 26 Apr 2010 11:53
Did you try a union query as I suggested?

Could you answer Al's question? I can't pick out any field names from your
reply.

You stated: "information from each form"
Information is not stored in forms, it is stored in tables.

--
Duane Hookom
Microsoft Access MVP


"Stuart" wrote:

> Thanks for the response, I have 3 tables that collect information on:
> 1. Sales.
> 2. Purchase Orders.
> 3. Expenses.
>
> As these forms are seperate and each entery is DATE Entered specific I now
> need to extract the information from each form and place them into one report
> that queries each form DATE ENTERED Specific. This may cause me problems I
> don't know.
> After I exstract the information into the report I want to then calculate
> Sales totals, Purchase Order Totals and Expenses to get TAX total.
>
> Hope this helps you.
> Cheers in advance. Stu
>
> "Al Campagna" wrote:
>
> > Stuart,
> > What is your table structure/s for the three forms.
> > One table? Three tables?
> > Please give us some detail about the important fields in your table/s
> >
> > What is the logical association between the 3 forms?
> > Does a particular Store have Sales, Expenses, POs?
> > Or... does an Region have Sales, Expenses, POs?
> > --
> > hth
> > Al Campagna
> > Microsoft Access MVP 2007-2009
> > http://home.comcast.net/~cccsolutions/index.html
> >
> > "Find a job that you love... and you'll never work a day in your life."
> >
> > "Stuart" <Stuart(a)discussions.microsoft.com> wrote in message
> > news:5E817937-C066-4BA0-9634-C279C5D3F946(a)microsoft.com...
> > > Hi All,
> > > My problem is that I have 3 Accounting forms:
> > > 1. Sales
> > > 2. Expenses
> > > 3. Purchase Orders
> > >
> > > I now want to extract certain fields into one Tax Return Report. The
> > > fields
> > > will be to 1. Sales.Total Cost
> > > 2. Sales. Tax
> > > 3. Expense. Total Cost
> > > 4. Expense. Tax
> > > 5. Purchase Order. Total Cost
> > > 6. Purchase Order. Tax
> > >
> > > Once all these are on the report I can then caluculate as I need, My
> > > problem
> > > is that I cannot get them on one report. And finally I want to DATE
> > > Entered
> > > query.
> >
> >
> > .
> >
 |  Next  |  Last
Pages: 1 2
Prev: Sorting and Grouping
Next: How to reference main report field in subreport calculation