My question is, how would you know that they have been printed? There would
have to be some sort of criteria, like a date of print or a last update date
or something to let you know those records have been printed. Otherwise, how
would you know how to put in query criteria to only update those that hadn't
been? If the records are null, you could use Is Null as your update query
criteria. If the records are not null, you could use Is Not Null. If the
records have some sort of verification of print, use that.
--
Milton Purdy
ACCESS
State of Arkansas


"Amy E. Baggott" wrote:

I have a report that generates assignment sheets for exhibitors who have
received booth assignments so that the orders can be updated (for various
reasons, we don't want the sales staff updating the orders directly). There
is an update query that then flags those assignments as printed so that they
are not printed again. During the early part of the show year, when we are
assigning the bulk of our exhibitors, these runs can quickly grow to 60
sheets or more. What I'd like to do is be able to run them in smaller groups
that are easier to manage so that each support person can run a batch, assign
them, run the invoices and floor plans and pass them on for proofing, then
run another batch to keep the process moving. I know how to limit the number
of records in the query that drives the report, but I don't know how to limit
the number of records in the update query to update only the records whose
assignment sheets have been run. I tried just tying in the query that drives
the report, but it is not updatable, so the update query bombs. (I have
never understood why Access cares whether a subquery is updatable if you are
not trying to update the information in that query, but that's another rant
for another time.) In the meantime, I'm trying to figure out how to make
sure that only the records that have actually BEEN printed get MARKED as
printed because if any fall through the cracks, it can be a major mess.

Can anyone help me?
--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson