OK we have a table with the field of "Status" which is a combo box on the form, with 4 values. How to I get the existing records to change to the default value of "Used" It will change the new records but as we have 10,000 records or so we really dont want to do it by hand. Any suggestions would be greatly appreciated.
-
-
Sure do an update query. Thats the fastest and easiest way. If you need to know where to make the update query its really easy. Click on the Query view, select query in design view. Then select the table you want to use. Next to the exclamation mark there is a query design button with an arrow next to it, select update query there and create your query.
Good luck -
Do I click the existing Query? Or create a new one. And if I do that it wont change all my other fields to the default value will it?Originally posted by maxamis4Comment
-
Originally posted by maxamis4
Disregard the last post I got it. Thank you for your help. That just "shows to go you" that you can always learn something new. Getting better at access every day. Thanks AgainComment
-
No problem sorry I didn't see your earlier message. Let me know how that update query works for youComment
-
Nice work Maxamis.Originally posted by maxamis4
You're getting some good answers in recently I see :)Comment
-
Thanks, Sometimes I wish I could do more.Comment
Comment