By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Table Help

P: 18
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.
Feb 22 '07 #1
Share this Question
Share on Google+
6 Replies


maxamis4
Expert 100+
P: 295
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
Feb 22 '07 #2

P: 18
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?
Feb 22 '07 #3

P: 18
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

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 Again
Feb 22 '07 #4

maxamis4
Expert 100+
P: 295
No problem sorry I didn't see your earlier message. Let me know how that update query works for you
Feb 22 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
No problem sorry I didn't see your earlier message. Let me know how that update query works for you
Nice work Maxamis.
You're getting some good answers in recently I see :)
Feb 26 '07 #6

maxamis4
Expert 100+
P: 295
Thanks, Sometimes I wish I could do more.
Feb 26 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.