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.