 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2007Query help
I have a table which has differnt numbers in time like 1.77 (thats what shows in my table) is 1 hour 46 minutes and so on in a field name called DT Regular. I want to add .83 to each of the times in my table for every record in the table. The field name is called DT Regular that I want to add the .83 to each record for that row. How would I do this with a query? Create a query based on your table and include the field, DT Regular. With the query in design view, click on the button in the menu for types of queries. Change your query to an Update query. Under DT Regular you will see a box that says Update To. Type in [DT Regular]+.83. Run the query. Access will ask you if you want to update XX fields. Answer Yes. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com >I have a table which has differnt numbers in time like 1.77 (thats what >shows [quoted text clipped - 4 lines] > .83 > to each record for that row. How would I do this with a query? Awsome!! Thanks... > Create a query based on your table and include the field, DT Regular. With > the query in design view, click on the button in the menu for types of [quoted text clipped - 15 lines] > > .83 > > to each record for that row. How would I do this with a query? thanks!!! > Create a query based on your table and include the field, DT Regular. With > the query in design view, click on the button in the menu for types of [quoted text clipped - 15 lines] > > .83 > > to each record for that row. How would I do this with a query? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.