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

    Query Criteria (2002)

    I would appreciate anyone
    Attached Files Attached Files
    Easy Access

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

    Re: Query Criteria (2002)

    You can do this in two steps:
    - First, create a totals query that calculates the most recent datDirectNext date before today for those clients. I've called it OverdueAux in the attached database. If this is all you need, you're done.
    - If you want to see all fields for these records, create a query based on the table and on OverdueAux, joined on ClientID and the date field. Add all fields from the table to the query. This is the modified Overdue query.

    See attached database.
    Attached Files Attached Files

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

    Re: Query Criteria (2002)

    Thanks you so much Hans...as usual your solutions are exactly the answer I needed.
    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
  •