Labels-how omit names that don't have addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an alumni database. I have approx 1400 names. Not all names have
addresses, though. Also, in the table, I have a column called FIRST NAME and
a column called NICKNAME (Thomas and Tom).

When I created an address label I chose:
Nickname Firstname Lastname
Street address
City, State Zip

How do I have Access NOT create labels for names that do NOT have addresses?
How do I have Access NOT print BOTH nickname and firstname (I just want to
print nickname with lastname, but if no nickname is given then print
firstname with lastname)?

Thank you.
 
First, modify your query so that records without an address do not pull.
Under the address in the criteria of your query just put something like
Not Null.

As far as the name, you could use the Nz function:


=Nz([NickName],[Firstname]) & " " & [LastName]
 
Smags,
If I understand correctly...
1. To prevent labels with no Address from printing, place this criteria
in your [Street Address] field...
Is Not Null
2. Create a calculated field in your query to handle the
NickName/FirstName logic... (all on one line)
FullName : IIF(IsNull(NickName), FirstName & " " & LastName,
NickName & " " & LastName)
Place that FullName field on your label instead of the Name field/s
you have now.
 
I'm new to this, so I cannot find the CRITERIA field when I click to
highlight the HOME STREET ADDRESS text box. Or, do I put the wording IS NOT
NULL under the FORMAT field?

How do I create a calculated field for the query to handle the first/nick
name logic? I need EXACT directions...sorry.
--
smags


Al Camp said:
Smags,
If I understand correctly...
1. To prevent labels with no Address from printing, place this criteria
in your [Street Address] field...
Is Not Null
2. Create a calculated field in your query to handle the
NickName/FirstName logic... (all on one line)
FullName : IIF(IsNull(NickName), FirstName & " " & LastName,
NickName & " " & LastName)
Place that FullName field on your label instead of the Name field/s
you have now.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

smags said:
I have an alumni database. I have approx 1400 names. Not all names have
addresses, though. Also, in the table, I have a column called FIRST NAME
and
a column called NICKNAME (Thomas and Tom).

When I created an address label I chose:
Nickname Firstname Lastname
Street address
City, State Zip

How do I have Access NOT create labels for names that do NOT have
addresses?
How do I have Access NOT print BOTH nickname and firstname (I just want to
print nickname with lastname, but if no nickname is given then print
firstname with lastname)?

Thank you.
Click to expand...
Click to expand...
 
Back
Top