Non Duplicate Fields on Reports

[Go3Team]

I am trying to do a report that lists 2 different entrys from the same table (or query). But when I do the wizard :/ it only lets me pick from the table or query only once. How do I go abt having the program differentiate between the two entrys and list the data I want listed?

 

[Pat Hartman]

The detail section of a report is produced once for each row of the report's recordsource. So, if the recordsource contains 2 rows, the report contains 2 occurances of the detail section. You don't need to select the columns multiple times.

 

[Go3Team]

Ive got it temperarily(spl?). Had to do a query for each one.