Results 1 to 2 of 2

Thread: Date Query

  1. #1
    New Lounger
    Join Date
    May 2001
    Location
    North Ridgeville, Ohio, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Query

    Hello,
    I have a table that users are entering templates defining certain characteristics of a product. At different times, these characteristics change, so the users are entering a new line, with the same product, but different characteristics, so I can track the changes (I have a field that automatically enters the date the record was added).
    I need to create a query that will select the most recent record for a given product and am having trouble. I've tried grouping by product and displaying the "last" date, but I can't get it to work, it shows all records.
    Can someone help me set this up?

    Thanks,
    DRA

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Query

    When you say the users are entering a new "line", do you mean a new record? If so, and the Date Added field is Date/Time type, try using a Totals query, grouping on Product and using the Max function on Totals row for the Date Added field.

Posting Permissions

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