Selective Update Query

N

Novice2000

I have a table with multiple customers each identified by a policy number.
Each is also assigned one of 20 HMOs. They have had the chance to change
HMOs. I have a list of the policies that have changed HMOs.

Is there a way to write a query that will select each policy number in the
main table and update just the HMO for that policy?
 
J

Jeff Boyce

I don't have a very clear picture of your table structure. Since queries
depend on (and in your case, will modify) the data, you'll need to start at
the data...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

Create a query with both tables - main table & policies that have changed HMOs.
Join the two tables on the police numbers. Run the select query and look
the data over. If it is ok then change to update query and run.

I think you would be better served if you used another table that linked
policy holder to HMO and included date of start, date of terminate, reason
for terminate, etc.
 
Top