Results 1 to 2 of 2
  1. #1
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209

    WHERE Question


    I need to setup a query with multiple where conditions. How do I set that up? So just for examples sake, let's say I need my query to show ID, Name, City, State, Zip where ZIP = 12345 Or 45523 Or 88762

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    SELECT ID, Name, City, State, Zip
    FROM tblTest
    WHERE ((zip) = 12345 or (zip) = 45523 or (zip) = 88762)

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

Similar Threads

  1. Replies: 4
    Last Post: 08-25-2012, 07:19 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