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!

  • Congratulations TouchToneTommy 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

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