I need to have a query that will:
If there is an individual's e-mail then insert the e-mail;
if no (individual's) e-mail then the query will grabe the the city's e-mail and insert it
instead.
Novice
Windows XP 
Access 2003
I need to have a query that will:
If there is an individual's e-mail then insert the e-mail;
if no (individual's) e-mail then the query will grabe the the city's e-mail and insert it
instead.
Competent Performer
Windows XP Access 2000
What you need is a calculated field.
You could try a couple of approaches:
The simplest might be the Nz function
Code:CalculatedEmail: Nz([FieldNameContainingIndividualEmail_Here],"EmailAddressToUseIfBlank_Here")
Posting Permissions
Reply With Quote