Results 1 to 2 of 2
  1. #1
    Skybeau is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Dec 2011

    Using date variables from table in query

    Hi guys,

    I have a table that contains dates (Saturday through Friday). When I set up my query, I would like data returned where the date in a field is between the Saturday date and Friday date. Is there anyway to do this n the query without hard coding the dates in and manually changing the dates every week?


  2. #2
    bcofie is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Oct 2011
    There is a weekday and weekdayName function you can use. Try those.

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

Similar Threads

  1. Using user inputs as variables in a query/report?
    By cheese9799 in forum Reports
    Replies: 3
    Last Post: 03-01-2011, 11:30 AM
  2. Replies: 9
    Last Post: 02-17-2011, 03:33 PM
  3. Date Lookup in Query for Junction Table
    By Phasma in forum Access
    Replies: 2
    Last Post: 01-21-2011, 03:36 PM
  4. Replies: 5
    Last Post: 06-10-2010, 05:46 PM
  5. Append Query using variables
    By hawg1 in forum Queries
    Replies: 2
    Last Post: 06-09-2010, 08:59 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