Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Query issue (where cell populated aswell as any of the other listed cells)


    I have a query im wanting to run on a table but i cant get the syntax to work with it.

    Im trying to get it to display records where "DateJoined" is populated, and any of the other cells listed in the query are populated (be that 1, 5 or all).

    E.g Date ="01/01/01"

    Name = ""
    Surname = ""
    MaidenName = "Johns"

    So it will pick this up because it has MaidenName populated.

  2. #2
    Join Date
    Mar 2009
    Try using the NOT ISNULL(fieldName) syntax.

    For example

    SELECT * FROM myTable WHERE NOT IsNull(LastName) AND NOT IsNull(FirstName) AND NOT IsNull(anyDateField)

    Hope that will help



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

Similar Threads

  1. change cell color
    By bishop743 in forum Programming
    Replies: 0
    Last Post: 02-01-2009, 11:00 AM
  2. VBA Opening Excel File and Placing Data in Cells
    By BobTHG in forum Programming
    Replies: 0
    Last Post: 01-13-2008, 03:01 PM
  3. Annoying Query issue
    By stevendavies in forum Queries
    Replies: 2
    Last Post: 05-08-2006, 02:35 PM
  4. CallTicketID populated to Order Form
    By EisBlade in forum Forms
    Replies: 0
    Last Post: 04-03-2006, 10:50 AM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 AM

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