Selective Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting, summing, matching, summing again... 1
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
How do I select the oldest/newest record in Access query? 13
Crosstab query possibly? 2
EMERGENCY! How can I update one table from another in a select que 5
Query to show all records of one table and updated info from anoth 3
Update query 2
Query to select individual records 4

Back
Top