update a table

[techkenny1]

Hi
I have a client database which as about 5000 clients.
I need to update their rates which is seven in total.
The client database is divided into several brokers which have different rates.
How can I just select by broker those clients and update these rates for all the clients (selected by brokerID) together.
The process at the moment on this db is to use a combo box and then to update the rates. but this is done singularly.
I am able to select the clients by broker ID which can give me a list which asssociates clients with their brokers.
Many thanks

 

[dhookom]

It seems the rates should be stored in the broker table, not the client table.

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi dhookom,
The rates are associated with each broker in a seperate table. when a new client is added and the broker is selected for that client those rates associated with the boker are then added to that client. When an invoice is generated all the data from the client is then added to the invoice which includes the rates. i think that this was done as some clients can have several brokers with differing rates.

Ken

 

[dhookom]

You should provide your significant table and field names. I don't know how anyone can provide an answer without knowing your structure.

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi Dhookom,
I did some more work on this one and managed to solve this problem i am able to update all clients at one time.
many thanks for your replies.

Ken