MS Access Experts:
I'm trying to create a report from 2 queries which come from 2 corresponding tables, mind you that these 2 data sets are unrelated.
This is more-or-less the format I would like my report to be like:
====================================
Report: Between 06/01/2003 to 06/06/2003
Table1_Setups Table2_Setups
6/1/03 12 3
6/2/03 27 7
6/3/03 23 6
...
Total: 62 16
====================================
For example, I have already figured out that on the Report Footer, it should be 'Total: =Count([xID]) =Count([yID])', where xID and yID are unique identifiers for their tables.
But how does one figure out the middle and where does it go? I am having difficulty especially b/c the Dates from table1 and table2 are set different, i.e. xDate and yDate (not related at all).
Thanks in advance!
I'm trying to create a report from 2 queries which come from 2 corresponding tables, mind you that these 2 data sets are unrelated.
This is more-or-less the format I would like my report to be like:
====================================
Report: Between 06/01/2003 to 06/06/2003
Table1_Setups Table2_Setups
6/1/03 12 3
6/2/03 27 7
6/3/03 23 6
...
Total: 62 16
====================================
For example, I have already figured out that on the Report Footer, it should be 'Total: =Count([xID]) =Count([yID])', where xID and yID are unique identifiers for their tables.
But how does one figure out the middle and where does it go? I am having difficulty especially b/c the Dates from table1 and table2 are set different, i.e. xDate and yDate (not related at all).
Thanks in advance!
