Change a range of data in a query

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

I just realized a mistake in our database. I need to change 100,000+/-
entries. I have a query that shows me all the wrong entries, so is there a
way I can select a range of wrong data can change it from 83 to 157? My
query isn't exact enough to show me just the wrong data, but I can modify it
to do so.

Thanks
Chad
 
Chad

Have you looked into using an Update query? (see Access HELP)

CAUTION!!! Be sure you have your database backed up BEFORE you run an
update query.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Hi Chad,

First, make a backup copy of your database. This is something that you
should do before running any action queries (action queries change data as
opposed to select queries which only display data).

Do modify your SELECT query so that it is *only* returning the intended
records, and no other records. Then, in query design, change the query to an
Update query. Fill in the 157 value in the Update To row that you should see.
Run the query. If something goes bad, restore from your backup copy and try
again.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
Back
Top