[SOLVED] Having trouble with Multiple Tables in 1 Report.
###### UPDATE ######
Figured it out, just used two sub-reports in the main report.
Thanks anyway!
######
I'm having trouble querying two tables in one report. I have the actual query down (here it is).
Basically both of the tables/recordsets are shown in the report, but when one table/recordset is longer than the other, then the short one repeats itself until it is equal in records.
Is there any way to stop this happening?
###### UPDATE ######
Figured it out, just used two sub-reports in the main report.
Thanks anyway!
######
I'm having trouble querying two tables in one report. I have the actual query down (here it is).
Code:
SELECT * FROM Table1, Table2
WHERE (Table1.[ID]=ID)
AND (Table2.[ID]=ID)Is there any way to stop this happening?
Last edited:
