Results 1 to 2 of 2
  1. #1
    Phlee is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2011
    Posts
    4

    Queries with multiple criteria that can be left blank

    Hi,

    I am pretty new to Access (first project)

    I know how to make a query by form where I can query using selected information on a form.



    I have 2 specific questions:

    1. How do I do this with multiple criteria? Also, if I add multiple criteria, is it okay if sometimes some of those criteria are left blank?!

    2. How can I make a date range a criteria?

    Thanks!

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    Multiple criteria can be in several ways, which one is in your mind. Create a sample Query with what is on your mind and provide the SQL as sample.

    If you look at the Ms-Access sample database: C:\Program Files\Microsoft Office\Office11\Samples\Northwind.mdb you can see several examples of Queries.

    You can find few examples here: Multiple Parameters for Query

    For Date Range: Between [StartDate] AND [EndDate] in the Query criteria row.
    or
    >=[StartDate] AND <= [EndDate]
    or
    Between #01-31-2011# AND #06-15-2011#

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

Similar Threads

  1. Replies: 1
    Last Post: 07-13-2011, 11:00 AM
  2. Queries Criteria with date
    By dssrun in forum Queries
    Replies: 4
    Last Post: 04-21-2011, 12:50 PM
  3. crosstab queries (criteria) won't work
    By Rich P in forum Queries
    Replies: 1
    Last Post: 02-15-2011, 10:53 AM
  4. Replies: 3
    Last Post: 02-02-2011, 01:00 PM
  5. Replies: 1
    Last Post: 07-02-2010, 03:55 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