Question Locked

Microsoft Access - Selecting Records that Match Date Criteria

0 helpful

2 replies

by tryan Sep 14, 2007 last reply Sep 14, 2007 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a field in my table titled "FilDate." I want my query to find all records where the "FilDate" is within 2 months of another file date.

Thanks, Teresa

2 replies

Clarifications

Let me rephrase my question. I have two fields to query:

Author (more then one author maybe associated with a record); and FilDate.

I want my query to return any record that contains a common Author and the FilDate is within 60 days of each other.

All assistance is appreciate.
Teresa

This discussion is closed to new replies.