Time and Date for reminder of a invoice is due

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have queries that have invoice, each invoice is paid ether monthly,
quarterly, simi annually, or yearly how do I set a reminder that the report
is do off the calender on the data set.
 
Add a number field to your invoice for PD_Months and enter 1 for monthly, 3
for quarterly, etc.
In the query criteria under your date field use --
<= DateAdd("m",-[PD_Months], Date())
 
Back
Top