Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Create a query to display records for this week

    I am designing a database in access to create a delivery list. The user will entre the delivery date into database as part of a record but I want to create a few queries. 1 that display all enteries for this week (Monday to Sunday), 1 for next week, and one for last week.

    Any help will be much appreciated.

    Regards

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You'll find functions here that should get the appropriate dates for you:

    Layout 1
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •