access calculation HELP!

N

Natalie

when i create a query report i want to divide everyone
salary by 24 how would i do that? Where do i go? What do
I click? Salary is entered into a table named
employeetable anyone please help!
 
D

Douglas J. Steele

Create a query that contains all of the fields in your table. In the field
that contains the salary, add /24 after the name of the field. That will
create a calculated field that will be named Expr1 in the resultant
recordset. Since Expr1 can be confusing, you might want to rename the field
by putting a name followed by a colon (like Salary24:) in front of the
expression you created.
 
Top