Report not getting all data from Table/Query

[Guest]

I have a report that runs a query. That query is pulling data from three
different tables. The report will not print the data unless I have
information in all three tables. Example: Primary key would be car's VIN,
which would be the same for all three tables, the first table shows date
manu, the second shows date shipped, and the thrid shows date received. When
I print my report the report does show all of the data unless I have all the
fields filled-in on all three table. My print out would start out (from left
to right) VIN, date manu, date shipped, date received.

How do I fix this?

 

[Marshall Barton]

I have a report that runs a query. That query is pulling data from three
different tables. The report will not print the data unless I have
information in all three tables. Example: Primary key would be car's VIN,
which would be the same for all three tables, the first table shows date
manu, the second shows date shipped, and the thrid shows date received. When
I print my report the report does show all of the data unless I have all the
fields filled-in on all three table. My print out would start out (from left
to right) VIN, date manu, date shipped, date received.

You should forget about the report until you can get the
query working properly.

Open the query in design view and then click on a line
joining two tables. Then right click on the line, select
Join Properties from the pop up menu and select the option
that you need for the report. Repeat for all three date
tables.