Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report showing the last 7 days ? (Access 2000)

    I have a report that shows the daily reports of the calls made by our dealers. In the Sorting and Grouping section of the report
    i have CallDate set on perDay. In the field CallDateHeader of the report i have the following expression :
    =Format$([CallDate];"Long Date";0;0)
    The above reports shows all the records of the calls. Is it possible to make the report showing always the prevous 7 days and not all
    the records.So, i imagine, to substract the present date with 7 and thus confine the report to the last 7 days ?

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report showing the last 7 days ? (Access 2000)

    If you go to the query bedhind the report you could add the criteria
    >Date()-7
    to your date column

    HTH

    Peter

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

    Re: report showing the last 7 days ? (Access 2000)

    If the Record Source of the report is a table, create a query based on that table, and use the query as Record Source.

    Open the query that acts as Record Source in design view, and add the following condition in the Criteria line under CallDate:

    Between Date()-7 And Date()

Posting Permissions

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