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" wrote in message
...
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.