G
Guest
Hi there,
I have something of a conceptual question to try and work out how to do what
I would like.
I have a three tables and a set of queries based on them. The queries are
sequential for example query1 = number of entries from Table 1 Present in
Table 2.
query 2 = number of entries from Table 3 not in query 1.
I would like to count the number of entries in each of the queries and have
the numbers displayed ina summary report. To do this I have created a second
set of queries that simply count the number of entries in the 1st set of
queries - the result of this second set of queries is just a one number
total. I would like to get all these totals together in a report somehow but
am lost as to how to do it?
When I try using the report wizard it simply gives me an error saying that
because all the fields I want are based on each other it won't do it (or
words to that effect). If anyone can help I will be delighted!!
I have something of a conceptual question to try and work out how to do what
I would like.
I have a three tables and a set of queries based on them. The queries are
sequential for example query1 = number of entries from Table 1 Present in
Table 2.
query 2 = number of entries from Table 3 not in query 1.
I would like to count the number of entries in each of the queries and have
the numbers displayed ina summary report. To do this I have created a second
set of queries that simply count the number of entries in the 1st set of
queries - the result of this second set of queries is just a one number
total. I would like to get all these totals together in a report somehow but
am lost as to how to do it?
When I try using the report wizard it simply gives me an error saying that
because all the fields I want are based on each other it won't do it (or
words to that effect). If anyone can help I will be delighted!!