Calculated control not working, no error message

[Guest]

I have an unbound calculated control on a form. It's control source is two
fields, set up as bound controls on the same form, and looks like this:

=([Amt]*1000)/([Stock Conc],1)

I used the Expression Builder window to create the expression and so chose
my fields by dbl clicking on them from the list ( so no spelling errors). I
recieved no error messages when I completed this task. But when I go into
Form view and input data into the 'Amt' and 'Stock Conc' controls I get no
results in my calculated control; it just remains blank. Any ideas why? See
below for details.

Control Bound Bound
Calc. Unbound
Name Amt Stock Conc Text 22
Format General Number General Number General Number
Decimal Places 2 2 3
Control Source Amt Stock Conc see above

Field Name Amt Stock Conc
Format Decimal Decimal
Precision 10 10
Scale 3 3
Decimal Places 2 2

 

[Lynn Trapp]

What is the purpose of the '1' in your expression?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Solved:

=[Amt]*1000/[Stock Conc]