data for member directory

W

William Lynch

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
 
R

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.
 
B

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.
 
W

William Lynch

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.
 
W

William Lynch

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

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

If not, then the query should pull all records.
Click to expand...
 
W

William Lynch

That was it exactly. Thanks!

Brendan Reynolds said:
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.
Click to expand...
 
Top