data for member directory

[Guest]

I'm trying to create a query that I can use to import into a contacts folder
so can print a membership directory for the staff. The problem I'm having is
that if a member doesn't have information in a field (say an email address)
the query excludes the member all together. Any thoughts?

Billy

 

[Rick B]

Does your query include criteria to exclude records with no entry in the
email field?

If not, then the query should pull all records.

 

[Brendan Reynolds]

Open the query in design view, and select 'Join Properties' from the 'View'
menu. You'll probably be able to take it from there yourself once you've
seen the 'Join Properties' dialog box, but feel free to post back again if
you need any more clarification after you've seen it.

 

[Guest]

The email field was just an example. Say I'm trying to create a query that
pools Company name, address, phone and fax from diffrent tables. If a company
doesn't have a fax number it won't be included in the results. I'm new at
this so I'm fumbling around in the dark.

 

[Guest]

I think I've got it. I skipped the wizard.

Does your query include criteria to exclude records with no entry in the
email field?

If not, then the query should pull all records.

 

[Guest]

That was it exactly. Thanks!

Open the query in design view, and select 'Join Properties' from the 'View'
menu. You'll probably be able to take it from there yourself once you've
seen the 'Join Properties' dialog box, but feel free to post back again if
you need any more clarification after you've seen it.