What triggers the generation and sending? Could you not include the current
date in that process? Obviously, you'll have to come back and update the
reminder date/indicator when the reminders are sent.
As we can't be sure _how_ you are going about all this, it's difficult to be
specific. If it were my application, I'd likely have a form to trigger
sending reminders and run a query from code when I sent them.
Larry Linson
Microsoft Access MVP
"Dumbo Liz" <du**********@yahoo.co.uk> wrote in message
news:17**************************@posting.google.c om...
My small database has now developed and is used to send out invoices
and invoice reminders. I have an "invoice sent" field in the table,
select records where this is "null" to identify the correct records
and generate invoices, then run an Update Query to insert todays date
in the table. (I'm using a similar process for reminders)
I am a novice, and this seems a rather chunky way of doing things. Has
anyone got a slicker/quicker way??