Capture 1st Date that an Invoice is printed

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I need to get the date and have it on a report for the
date that the Invoice(report) is first printed. If the
invoice is pulled back up on a future date I need that
same date to be on the invoice.

Please help.

Thanks,
Barb
 
What about an update query, and in the update to enter:
IIF([printdate] is null,now(),printdate)
You can run the update query at report open
Hope this helps.Fons
 
Back
Top