1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

MS Access 2K: Date (Criteria) Query

Discussion in 'Business Applications' started by keith10456, Feb 11, 2005.

Thread Status:
Not open for further replies.
  1. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    I'm trying to create a query that prompts the end-user for the date fields to search.

    For example, I have an Invoice table that contains a "InvoiceDate" field. I want the end-user to be able to search for invoice dates between 'date A' and 'date B'.

    More or less, I need to know how to setup the "criteria" in design view of the query.


    Any/all help is appriciated...

    I'm using MS Access 2K
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Between [Begin Date"] and [End Date:]

    It will prompt them for each value.
     
  3. keith10456

    keith10456 Thread Starter

    Joined:
    Mar 17, 2004
    Messages:
    190
    This is exactly what I needed!

    Many, many thanks!!!!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/329308

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice