Calculating comboboxes

  • Thread starter Thread starter LRay67
  • Start date Start date
L

LRay67

I have a form that has two fields that are not calculating right.

[RemoteNumberHours] = 0.25
[NumberPCS] = 1

Code behind:
=[RemoteNumberHours]*[RemotePCS]

This should work, but it is giving me a total of 1 instead of 0.25. What am
I doing wrong?
Thanks
Linda
 
Looks to me like the code behind ought to be
[RemoteNumberHours]*[NumberPCS]
 
The destination variable is an Integer type. Make it a Double or Float.
 
You must log in or register to reply here.

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

Similar Threads

evaluating power of powers and reciprocals 1
Omit empty cells? 0
Calculated Field 4
subform resize??? 4
MS Access 2003 Formatting Hours Field 2
this is killing me. INDEX/MATCH "closest to X" in a smart way? 5
Need Help in Selecting PrintArea Dynamically .. 0
Calculated Field based on 2 Running Totals in PivotTable 3

Back
Top