query results

[jomara via AccessMonster.com]

I have a query that pulls data from 2 tables all works fine if there is data
in both tables. Unfortunatly the possibility exsits that one table might not
have any data therefor not exist for that customer and those results do not
show in my form where the query displays. I do not know sql very good so am
having a problem getting results to show when the table is missing

 

[Jerry Whittle]

In the query design window double click on the line between the two tables
until a dialog box pops up. Try the second option. If that doesn't work, try
the third option.

The first option, the default, is an Inner Join where you need matching
records in both tables.

The second option is a Left Join where it will show all the data in one
table and only matching records in the other.

The third option is a Right Join which does the same thing as the second
option but with the tables switched.

Now if the second option and third option both kind of work but don't return
all the expected records, you may well have an Outer Join which Access
doesn't support. There are ways around it. Reply back here if that's the case.

 

[jomara via AccessMonster.com]

Thanks for the help worked fine cant believe i didnt think of that