calculations in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am just learning how to use Access and need to calculate the amount of
commission to be paid to sales representatives. I have my database set up but
am not sure exactly how to perform the query. Any help would be greatly
appreciated.
 
Create a select query and in the design view grid add another output field
like this --
My Calculation: ([YourField1] + [YourField2]) * 1.4

Label the output followed by a colon. Use your field names, enclosed in
brackets, in standard mathmatical expressions. Above are two fields added
together and then multiplied by 1.4 that will appear as a field named 'My
Calculation' in the output.
 
I am just learning how to use Access and need to calculate the amount of
commission to be paid to sales representatives. I have my database set up but
am not sure exactly how to perform the query. Any help would be greatly
appreciated.
Click to expand...

You'll need to give us some help, Kate. If you were calculating the commission
on paper, what would you do? What information goes into the expression, and
how does that information get processed to give the commission?

The "short answer" would be to create a Query based on your table, and type a
valid expression in a vacant Field cell, such as

Commission: [Sales] * 0.08 + NZ([Bonus])

to multiply the value in Sales by 8% and add the value in Bonus; the NZ()
function converts a NULL value of Bonus to 0 before doing the addition.

John W. Vinson [MVP]
 
Back
Top