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

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

Thanks alot, worked like a champ ! ! !

Ricky