joins

[Guest]

I am creating a querie and for every member I may have one address or none.
The query is bring back only members that have a valid address. How do I
change it so I get all the members with addresses or blanks. thanks

 

[John Vinson]

I am creating a querie and for every member I may have one address or none.
The query is bring back only members that have a valid address. How do I
change it so I get all the members with addresses or blanks. thanks

I have no idea, because I do not know the structure of your table, nor
of the query that you are using. Please open your current query in SQL
view and post it here.

John W. Vinson[MVP]