Selective Update Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Novice2000 - 31 Oct 2006 18:03 GMT

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?

Reply to this Message

Jeff Boyce - 31 Oct 2006 19:14 GMT

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

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

Reply to this Message

KARL DEWEY - 31 Oct 2006 19:18 GMT

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.

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

Reply to this Message