I have a table that has personnel names in one field, then in several fields are expiration dates for various licenses they hold.

Can I construct a query that will let me enter in a certain month/year as a parameter and it would bring up all of the licenses which expire that month/year along with the personnel name?

I've looked at DatePart but am really confused. I know just enough about Access to get into trouble http://www.access-programmers.co.uk/ubb/smile.gif

Create your parameter as a separate field in the query, say you name that parameter field DateToCheck.

In each field with the dates, put

<[DateToCheck]

as the criterion using OR (different criteria lines for each field to check).

I want to do this but with a shot record (immunization) database. I don't quite understand this last post but am willing to learn. Don't exactly know where to start, tried this above but didn't work out right. Could someone lend a helping hand and go into a lil more detail. Thanks