How can I make a query that will take a field that I already have set to record the last contact date and check it against today's date to give me the span between the two?
DateDiff("d", [MyDate], Date())
You may have to play with the sequence (if it comes out - then reverse the two) and I think number of days is "d" but if not try Access Help on datediff.
Hope this helps
Good luck
