Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: want query to show latest months worth of data

    Hello!
    I am setting up a query and report, and want the report to show only the lates month worth of data. The entries of data have dates such as 5 June 04 and I want the report to automatically run for eg "June 04" - ideally this would be typed by the user. What do I enter and where? Many thanks for your help in advance.
    :-)
    Sheila.
    PS. No VB code etc - only doing this in query design view, or please provide more detail if providing me with help in report design view as I am fairly new to this. Thanks again.

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Try using this:

    >Date() - day(date())

    as a criteria....

    Greetz

  3. #3
    Join Date
    Jul 2004
    Posts
    6

    Thank you - this worked! :-)

    Thanks, your suggestion worked.

    Sheila.

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    *AHEM*

    But offcourse

Posting Permissions

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