Results 1 to 3 of 3

Thread: Modify query to display data that ends on or after a certain date?

  1. #1
    BBpatriotStorm is offline Novice
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Posts
    1

    Exclamation Modify query to display data that ends on or after a certain date?

    I dont know if this question has been asked before but i need a quick answer to this problem:

    The database is complete and i am in the query but i need to display contracts with a specific contract date ending on or after a certain date.

    the actual step is this:
    "Modify the Current lessons query to display all contracts that end on or after 7/1/2010."

    i dont know why but i cannot seem to think straight right now!

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    927
    Let me get this straight you have some data that you want to query with a date criteria.

    Suppose you want to view data between two dates: Between #1/2/2010# And #1/12/2010# type this expression in the criteria of your date field in your query.

    Now if you want to type the dates yourself without actually putting it in the criteria

    Between [Type:Starting Date] And [Type:Ending Date]. Every time you run the query you will be prompted to type the Starting and the Ending Date. If you type the same date from both then data for that day will be displayed.

    Please mark the thread if this solves your pronlem

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    927
    have you been able to solve your problem if yes please mark this thread solved

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

Similar Threads

  1. How Can I Modify the currency symbol programmatically
    By migo702000 in forum Programming
    Replies: 5
    Last Post: 11-03-2009, 02:34 AM
  2. a simple "display date " query
    By Ushera in forum Queries
    Replies: 2
    Last Post: 07-31-2009, 05:49 AM
  3. Import and Modify data
    By crownedzero in forum Forms
    Replies: 7
    Last Post: 06-16-2009, 10:58 AM
  4. Report to display multiple records by date.
    By af01waco in forum Reports
    Replies: 1
    Last Post: 03-21-2009, 01:12 PM
  5. Replies: 6
    Last Post: 02-20-2009, 09:50 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
  •  
Tech Forums: Microsoft Office Forums