Rounding input Value based on another field

A

Andy

Is it possible to build a macro that will round input values in a field based
on the value in another.

[PayItem]![Quantity] [Inventory]![ProductCost]

0.1 $0.1 to $9.99
0.01 $10.00 to $99.99
0.001 $100.00 to 1000.00
0.0001 $1001.00 to 10000.00
0.00001 $10001.00 to Infinity

[PayItem]![Quantity] is long intiger and [Inventory]![ProductCost] is Number
$ field.

Is this possible?
 
D

Douglas J. Steele

If Quantity is a long integer, then it can only have integral values. In
other words, you cannot have values like .1, .01, .001 etc. for it.
 

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

Significant digits 1
Macro for rounding input in one field based on values in another f 4
Display Time based on another field value 2
Opening Form Based on Value Input 1
Create default text based on another text field 1
DSUM specific records based on another field 5
Lookup value based on a value in another field on the same form 1
computation of calculated field in query based on conditions 3

Top