If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Labels-how omit names that don't have addresses
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. -- smags |
#2
|
|||
|
|||
Labels-how omit names that don't have addresses
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] -- Rick B "smags" wrote in message ... 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. -- smags |
#3
|
|||
|
|||
Labels-how omit names that don't have addresses
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" wrote in message ... 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. -- smags |
#4
|
|||
|
|||
Labels-how omit names that don't have addresses
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" wrote: 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" wrote in message ... 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. -- smags |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you display names instead of email addresses on emails? | V Fair | Contacts | 5 | December 22nd, 2005 09:44 PM |
omit blank fields in mailing labels in Access | Tigger2405 | Setting Up & Running Reports | 4 | November 20th, 2005 10:40 PM |
How do I set word to print addresses within labels on sheet? | IainC25 | General Discussion | 2 | September 27th, 2005 05:44 AM |
how do I select addresses for printing labels in Word? | newlin9 | General Discussion | 1 | June 24th, 2005 08:18 PM |
creating labels, not addresses, from an Excel file | some_guy79 | Mailmerge | 1 | June 11th, 2005 03:54 AM |