Finding number of days between 2 dates

[mlamont]

I am working on a school project and I have run into some trouble with a query. I need to find out how many days are in between 2 dates ie. Sept 1, 2001 and Sept 3 is 3 days. I am having trouble getting a numerical value. Can anybody help me?

 

[Fizzio]

Use DateDiff Function

eg DateDiff("d",[FirstDate],[SecondDate])

Use it in a calculated control box or as an expression in your query