Inside of a reporting program, I am querying a database that could contain a current and 0 to 6 historical records each with a date/timestamp. No problem in getting the current record, now I want the most recent historical record as long as it is at least 100 days older than the current record. A record would contain, user id, sequential record number, timestamp, name, weight. Can I do that with a query or am I going to need to collect all the historical records and test them inside my code? If I can do that with a query, what would that look like?