I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are
printed.

I already have a query which checks the date of first letter field,
and returns those customers whose date of first letter field is null.
How do I setup to run the mailing labels based on this criteria and
update the date of first letter field in the process?

Thanks

Dr Al wrote:

I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are
printed.

A single query can't do that. You could make a Macro to do that (not
resorting to VBA) where it runs the report based on the first query,
then runs an update query based on the first that sets the date.

2 lines of code...easy...

....or you can -=try=- to do it via VBA in a report...just add code to
currentdb.execute "UpdateQueryName" to the close event of the report.

On Apr 18, 8:44*pm, Harry Skelton <skelton.ha...@gmail.comwrote:

Dr Al wrote:

>
A single query can't do that. *You could make a Macro to do that (not
resorting to VBA) where it runs the report based on the first query,
then runs an update query based on the first that sets the date.
>
2 lines of code...easy...
>
...or you can -=try=- to do it via VBA in a report...just add code to
currentdb.execute "UpdateQueryName" to the close event of the report.

Thanks, but could you be a little more specific! You said...easy...,
but I am not that familar with code!
Thanks

Dr Al,

For what it's worth, when I do something like this I open a form based
on the select query and print my labels from there then in the onclose
event of the form I just run an update query to place a date in the
records I just processed.

Rick

On Apr 22, 10:49*am, "Rick A.B." <rick.bre...@minneapolis.eduwrote:

Dr Al,
>
For what it's worth, when I do something like this I open a form based
on the select query and print my labels from there then in the onclose
event of the form I just run an update query to place a date in the
records I just processed.
>
Rick

Thanks everyone,

I got it working this morning.... I would not have gotten it done
without your help.

Thanks