Hi,
I am trying to update mulitple records in a table, however I
can't seem to figure out a way to differentiate the fields. I used
a query to get all sales from a single customer using their
customer number. I sometimes end up with 2 or more records. I want
to mark both records as shipped (using a select statement with the
choices of shipped and not shipped) then update these at the same
time. However I have two values the field "shipping", one for each
record, I also have two values for the field "salesnum" (the key
for the sales table). If I just try to do a regular update query,
then I only seem to update the last record with the last set of
values.
Anyhow, I have been althrough the forums and books to find a
solution (not to mention tried several combinations of looping
through the query). Any help will be appreciated. Thank you.