Hi,

I have these fields and tables

Table: tblInventory
Fields:
LastUpdate (date)
FrequencyID (long)
etc

Table: tblFrequency
Fields:
FrequencyID(autonumber)
NumDays(integer)
etc

What I want to do is select all the inventory items for which maintenance is 'due'.

The NumDays field in the frequency table indicates how often (# of days) that inventory item requires maintenance.

How would I
1) select all inventory items for which the next maintenance date is today.
2) select all inventory items for which the next maintenance date falls in the current week.

I'm not familiar with the sql date functions so if you can either give me the solution to this or a hint, I'd be grateful.