Update multiple records from query

[Krash878]

qryBilling
tblChargeBack

The query takes all the records in tblChargeBack and does a sum on all records with the same BankID. I need to generate a bill for each bank and update the tblChargeBack’s field IsBilled with a 1/yes once it has been billed so it does not get billed again.

I am not sure how to even start this. Any help would be appreciated.

Thanks
Kenny

 

[dawnd3]

You would do an "update query". Start you query as you normally would and from the query menu choose update. You will see that this changes the bottom pane a bit. The field you want to update is the IsBilled field, to "yes" and the criteria is on the bankID field. So in the query grid, bring in only those two feilds and make sure that only the Isbilled field has something in the "update to" row. Does this help? Dawn

http://www.calliopeconsulting.net