I have an access database table which includes the following 2 fields (vendorID and Frequency) the Frequency column contains the following records (weekly, monthly, quarterly, half yearly and yearly) what i want to do is display the vendor records in a query which are due based on there frequency critea matching the current date.

for example

weekly in frequency will get displayed every week
monthly in frequency will get displayed every month
quarterly in frequency will get displayed every 4 months

i want this because i have a list of reports that get sent to me based on the frequency criteria, and it would help if i can have a querie that displays the reports i'm suppose to recieve and if not i can chase up on them.

i've heard that dateDiff() could be used for this?

Any help would be great?