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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query filter for end of current month 3
Setting reminders for Quarter Days 0
Quarterly Billing for Partial periods 3
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
set a payment date of 2nd of month 4
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Generating Invoice Numbers In Queries 5
Pls Help - "between" Criterea returning no results 11

Back
Top