2 Results from 2 Queries - How?

[net123]

Experts:

How can I create a simple report in MS Access 2000 in which it only has two values.

For example, I have two separate tables with user submissions, Entries1 and Entries2. I can easily create 1 query from 1 table and then by adding [Type beginning date] & " and " & [Type ending date] in the constraint area of the query, but don't know how to incorporate this into the report with 2 queries.

Is there a line of code to display just the count from query1 and query2.

For example:

===========================
Report:

Total between Date1 and Date2

E1 E2

===========================

Where E1 is something like: '
SELECT count(EntryID1)
FROM table1
where date ...

Please help.

 

[jrbarnett]

I'm sure you will get the gist from this:

SELECT count(EntryID1)
FROM table1
where date ...
union
select count (entryID2)
from table2
where date ...

John

 

[net123]

But how can incorporate user input into your select statement?

where date is [Enter date1 and date2]???

 

[jrbarnett]

Create a report selection form for entry of the two dates as per the following FAQ, which can then open the report passing across the data. You then don't need to bother with parameter queries.

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619

John