Checking records exist and updating

[Usless]

I have a database of clients and I change my rate charged annually. I have a customer table showing the year the customer is contracted for and a price table which shows my charges for the current year. As my business grows it is becoming a pain to manually update the charges in the member table. Is there a way of comparing the year of charges with the contracted year and then updating the price e.g. changing from 2012 prices to 2013? Could it also give me an error message if my client already has the price updated?

Thanks for any help you can give.

 

[PHV]

Use an UPDATE query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

This is very vague and convoluted question: “I have a customer table” “and a price table” [and I want to] “update the charges in the member table” – how are the tables related? What data do you have and what are you hoping to do?

Have fun.

---- Andy