Calculating Number of days

[Bill]

What do I need to do to calculate number of days? I have
a parameter query that I ask for start date and end date.
I want to calculate the number of days between the two,
but I get an error. The first date is named start, the
second date is called end. I have tried the following to
calculate number of days =[end]-[start]+1, but it just
says error. Any ideas?

 

[Les]

Try using the datediff function:

DateDiff("d",[start],[end])

 

[JoeL]

Try looking up DateDif in the help files - it should be what you're looking for