Results 1 to 5 of 5
  1. #1
    9944pdx is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Location
    PDX
    Posts
    44

    Query question/help

    I am working with a query in design view, my field looks like this:



    Notepad: [Location] & "" & [Notes]

    I have many locations but I only want a specific [location] to show in the [NOTEPAD] field if there happen to be [notes] in the field.

    Tried using the expression builder - it seems self explanatory but I am new to this sooooo.

    ex:
    IIf (<<expr>>, <<truepart>>, <<falsepart>>)

    Logically it seems easy but for some reason it isn't clicking.

  2. #2
    dsmacs is offline Advanced Beginner
    Windows XP Access 2010 (version 14.0)
    Join Date
    Oct 2009
    Location
    Perth Western Australia
    Posts
    52
    Include the notes field in the query and in the criteria enter "Is Not Null" and untick the "Show" checkbox.

  3. #3
    9944pdx is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Location
    PDX
    Posts
    44
    What is the difference between these fields?
    Ex:
    Notepad: IIf([Notes]="",[Location],[Location] & " " & [Notes])

    Ex:
    Notepad: IIf(IsNull([Notes])=True,[Location],([Location]+[Notes]))

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  5. #5
    9944pdx is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Location
    PDX
    Posts
    44
    Late reply, you helped thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Crosstab Query Question
    By hnguyen1987 in forum Access
    Replies: 1
    Last Post: 08-20-2010, 12:54 PM
  2. Query Question
    By starhannes in forum Queries
    Replies: 13
    Last Post: 05-06-2010, 04:05 PM
  3. Query Question
    By Guiseppe in forum Queries
    Replies: 5
    Last Post: 03-23-2010, 04:32 PM
  4. Query with a question
    By sagit3 in forum Queries
    Replies: 0
    Last Post: 06-11-2009, 07:10 AM
  5. Query Question
    By blewis in forum Queries
    Replies: 0
    Last Post: 04-16-2009, 01:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums