Question: how to calculate date in access query?
Answer: =DateDiff("d",Date(),[DueDate]) The expression in this example subtracts today's date (Date()) from the Due Date. The "d" tells Access to calculate the number of days (as opposed to years, months, etc.).