Join Property Help- Outer Join?

[bravo6]

I am trying to create a join between two tables where all rows from table one will be selected. The problem is that the field that I want to show in Table 2 is sometimes not used ie. It's not just a blank or zero in the field but when nothing is entered in the front line, the field does not exist in that record. This causes rows from table 1 to not appear for records in which that field was never created. I was told that an outer join may fix this but I don't know how to do that.

Thanks,
Dave

 

[dhookom]

Your question is very difficult to understand. Particularly "when nothing is entered in the front line, the field does not exist in that record". A field must exist in every record of a table. It might not have a value but the number of fields can't vary record by record in a table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Use a LEFT join between Table1 and Table2.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Check out the Join link below....

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins