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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top