datediff function question

  • Thread starter Thread starter Anglo Stores
  • Start date Start date
A

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
 
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])
 
Back
Top