using a control box

  • Thread starter Thread starter Sally
  • Start date Start date
S

Sally

I created a form from a table. The form shows the
following information:
Purchase Price (format to currency)
Number of items (format to text)
Shipping Price (format to currency)
Miscellaneous Fees (format to currency)
Price Per Item (format to currency)

I want Access to automatically calculate the value for
Price Per Item after filling in the other information. I
set the control source of that field as follows: =
[purchase price]+[shipping price]+[miscellaneous fees]/
[number of items]
However, it does not calculate properly. Can someone tell
me what I am doing wrong?
Thanks!
Sally
 
I want Access to automatically calculate the value for
Price Per Item after filling in the other information. I
set the control source of that field as follows: =
[purchase price]+[shipping price]+[miscellaneous fees]/
[number of items]
Click to expand...

My guess is that it is going:

(purchase price + shipping prices) + ([miscellaneouse fees] / [number of
itmes])

Just like your pocket calculator...division is usually done first..so, lets
force the issue with:

=( ([purchase price]+[shipping price]+[miscellaneous fees]) / [number of
items])
 
Back
Top