Query help

C

Chad

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

Steve

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
[email protected]
 
C

Chad

Awsome!! Thanks...

Steve said:
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
[email protected]





Chad said:
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?
Click to expand...
Click to expand...
 
C

Chad

thanks!!!

Steve said:
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
[email protected]





Chad said:
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?
Click to expand...
Click to expand...
 
Top