Query Off of another Query

[Richard_Marx]

I have 3 query's with the syntax below:


Query1

SELECT COUNT(ID) As CountOfID
FROM table1
WHERE saleDate BETWEEN [forms]![form1]![begin] AND [forms]![form1]![end]

Query2

SELECT COUNT(ID) AS COUNTOFID
FROM table2
WHERE saleDate BETWEEN [forms]![form1]![begin] AND [forms]![form1]![end]

Query3

SELECT [table1].[CountOfID]+[table2].[CountOfID]
FROM table1, table2

I want to run query3 from the push button on a form, and it display accurate data, but when I run query 3 it displays '0' when that is incorrect. How should I set this up?

[ssanfu]

You need to have Query1 and Query2 in Query3, NOT table1 and table2.

It would look something like

SELECT [Query1].[CountOfID] + [Query2].[CountOfID] AS total
FROM Query1, Query2