Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Report Criteria (2k2)

    I have a report that I would like to display records based on the following criteria.

    1. the report will contain a date field (ReminderDate) that all records will be filtered by.
    2. Based on the current date the report should only display those records whose ReminderDate field value fall within the range of the current week
    Easy Access

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Criteria (2k2)

    You can do either:

    In a query, set the criteria for ReminderDate to

    Between Date()-Weekday(Date())+1 And Date()-Weekday(Date())+7

    In VBA: use DoCmd.OpenReport to open the report and specify the WhereCondition argument:

    DoCmd.OpenReport "rptSomething", acViewPreview, , "ReminderDate Between Date()-Weekday(Date())+1 And Date()-Weekday(Date())+7"

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Report Criteria (2k2)

    Thank you Hans, as usual your suggestion worked perfectly and your assistance is greatly appreciated.
    Easy Access

Posting Permissions

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