Background info: My daughter's computer has Windows 2000 Professional. When she wanted to load a new game, it required her to log on as Administrator (which she is not old enough to spell). I wanted to change her rights to administrator so she can install her own kindergarten games. I did it...
I'm trying to create some address labels. I would like to show the Family Name (i.e. The Smith Family) if not null else I'd like to show Title & Last Name.
On my report design, this is what I have:
=IIf((Trim([Xmas])="xmas" And Trim([Family Name])<>""),UCase([Family Name]),UCase([Title)] & “ “...
Hi,
In my report, I publish each person's Last name, First name, MI, Suffix, Preferred Name, and Class Year. I would like to add quotes around the Preferred Name if the field is not null (if they have a nickname they prefer). Here's an example: Adams, Jeffrey M. "Jeff" '86
How do I add the...
I'm pulling the correct address based on Mailing Code = "H" or "W" but I need to pull the Title and Company fields if the code = "W". How do I add this to my Select statement? Also, is there a better way to write this?
Here's what I have:
SELECT LSPAAalumni.[Salutation], LSPAAalumni.[First...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.