I am trying to figure out a way to

[kirnavi]

I am trying to figure out a way to update a table column through a macro.

Our customer service dept gets people who need their checks stopped for one reason or another. This info gets entered into an Access form and sent once a day by a central person via a macro. Now they (customer service) would like to be able to send each of their own records and do it several times a day. The best way I can see of doing this is having the macro update a table column so that, say, all 1's are records that haven't been sent and all 2's are records that have been sent.

Any idea on how best to go about this? Best to do it in the query stage?

Thanks,
Susan

 

[KyleS]

Susan, this is very doable, but I think I'll need some more info.

The best way to do it is to use an update query. It the CSR's are sending X records, are the records they're sending being selected via a query? If so, right after the selection you could run an update query that's actually built off your existing query that updates all the 1's they just sent to 2's so they won't come up again. If I have some more detail I can put some more detail in my answer. Kyle :