Open the query in design view, double click the field from the table you want to appear in the report to add it to the query. Open the report in design view and drag the control from the Field List onto the report.
If that doesn't work, post your db here deleting ALL data within the tables and I'll take a look.
HTH
