Query range of dates from multiple fields in one table

[eggs3]

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

 

[shacket]

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).

 

[fixious123]

Expire

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