Blank fields on report???

[Muzicmn]

i have a db with two tables.....one has an incident basic information, such as case#, date, location etc..... the other table has reports on that case, this table includes fields such as case#(in order to sync with 1st table) time of reports, and so forth....

i created a query which will be used for a report. the query/report will pull information from both tables to print a summary of information. my problem is when there are no reports on a case, (table one still has the basic information but table two has no info to reference), the report will not even include the basic information from table one. What i have to do is input fake date in table 2 in order for the report to print out the info from table one. the case# field i am searching in the query is from table 1.

i prob should have posted this under the query section, since the prob is actually a query pblm not a report pblm, sorry about that.



appreciate any help

Ricky

 

[WayneRyan]

Ricky,

Get your query in Design View. Right-Click on the line
drawn between your two tables and select Join Properties.
Choose ALL from the Left table and only those Matching
from the right.

Wayne

 

[Muzicmn]

Thanks alot, worked like a champ ! ! !

Ricky