Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tripleblessed

    Accidentally changed/deleted Administrator now cannot log in

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

    IIF question

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

    IIF question

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

    IIF question

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

    Add &quot; &quot; if Preferred Name is not null

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

    Add &quot; &quot; if Preferred Name is not null

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

    Add &quot; &quot; if Preferred Name is not null

    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!
  8. tripleblessed

    Add &quot; &quot; if Preferred Name is not null

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

    Pull correct info based on Mailing Code = Home or Work

    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!
  10. tripleblessed

    Pull correct info based on Mailing Code = Home or Work

    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?
  11. tripleblessed

    Pull correct info based on Mailing Code = Home or Work

    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?
  12. tripleblessed

    Pull correct info based on Mailing Code = Home or Work

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

    Pull correct info based on Mailing Code = Home or Work

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

    Pull correct info based on Mailing Code = Home or Work

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

Part and Inventory Search

Back
Top