datediff function question

[Anglo Stores]

Hi ,

I've created a report,which shows date of order being placed,and
the date of receipt of that particular order.
I wish to "enhance" this report further,by adding a control,calculating the
number of days elapsed from date of order / receipt of order.
Can this be done using the DateDiff function within the report,or does it
need to be written into the query?

Thanks in advance


Gordon

 

[Allen Browne]

If you just want to display the value on the report (not sort or group by
the results), you can just type the calculation into the Control Source of a
text box, e.g.:
=DateDiff("d", [OrderDate], [ReceiptDate])