Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Question Unanswered: Automatically Query for Data from Previous Week

    Hello All,

    I am trying to create a query that will show me what projects my team members were working on for the previous week. I want to be able to have the query automatically return the data for last week without asking me for a date to input. Please help!

    Thanks
    Last edited by els4; 07-07-11 at 17:33.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You should find functions here to do it for you (using Between in your criteria):

    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
  •