Using 2 tables in one report....

[stlrain95]

I am using the REPORT wizard to create a report using fields from two separate, but linked, tables. I have started to build this report, but when I do a preview of the report. I don't have any data from the tables in it? I don't know where I am going wrong?

Does anyone have a suggestion?

 

[CosmoKramer]

Build a query with the fields you want, joining your tables appropriately, and use that query as your report's record source instead.....

 

[stlrain95]

Figured it out!! I had the relationship reversed in the relationship.

It is working now.

thanks.