Search results

  1. D

    query for last date on multiple records

    Thanks, I'll keep this in my pocket for future reference. Hah, not sure how that snuck in. Correcting that fixed the prompt that I previously mentioned. I'm still getting some duplicate line items along with some blanks, but I should be able to filter those out with Is Not Null and by removing...
  2. D

    query for last date on multiple records

    Hi, This is an old thread but I have the same problem as OP and am getting errors when using the solutions presented here. I am attempting to filter an ID by the most recent date while including additional information specific to the ID. My Example table: ID Date Frequency 1...
Top Bottom