Search results for query: *

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

Thank you for both of your replies. Shirley -I used the basic expression you suggested and it worked great. dhookom - I understand now about the "" is not the same as null. I guess I assumed that the blank fields were Null. I was only using Trim and UCase b/c I copied it from old code. I...

Hi Shirley, Thanks for your quick response. It still gives me an invalid syntax error. I also just realized that I do not need the ="xmas" part since my query is selecting these fields so I removed that part to show: =IIf((Trim([Family Name])<>""),UCase([Family Name]),UCase([Title)] & “ “ &...

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)] & “ “...

I got it!!! I just had to play around with it some more. Thanks again for all of your help!

That worked great - thank you! Now I've tried to use what you wrote to apply it to my next part but I'm getting an error. It's a similar situation - add an x before the Work Ext if the person has an extention. Please tell me what's wrong with my expression (and I apologize if I'm totally offbase...

Thanks, mp9 for the start of it. It did give me quotes around the nickname but unfortunately, it left " " for those people that don't have nicknames. Do you think I need some type of If statement and where would I put it? Thanks again for your help!

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

Never mind - I just realized that I can do the sorting by last name in the Reports/Labels part. Thanks again for all of your help!

That was it - I had selected Last Name in the ORDER BY field because I'm going to use this query to create address labels. Should I put the ORDER BY [Last Name] in my query somewhere?

Hi Remou, I was deleting old test queries and I somehow messed up the query we were working on. I renamed the query from Mailing Labels Query2 to same name w/o 2. When I go to run it, it asks me for a Parameter Value for Mailing Labels Query2.Last Name. What in the world did I do to it?

Thanks Remou! That was it. I appreciate your time and help.

The Union worked great until I added pulling the Title & Company fields if code = W. Error msg = # of columns in Union does not match. So, I'm assuming that it doesn't like the fact that I'm pulling 2 extra fields in the 2nd SELECT statement. Since a friend wrote the initial code, what is 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...