Rounding down or not at all in Forms

[JimiiZ via AccessMonster.com]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and Total,
then shipping and handling gets added in.....The List Price that comes from
the table is fine, you can click in that field and it shows 2 fixed decimal.
The other two fields are calculated. So that being said, take a list price
of 329.95 and a 25% discount which makes it 247.46 which when you click in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get the
numbers to round down 742.38 ??????

 

[Clifford Bass]

Hi Jimii,

Try:

Int([List Price] * (1 - [Discount]) * [Quantity] * 100) / 100

Clifford Bass

 

[o;;]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get the
numbers to round down 742.38 ??????

 

[o;;]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get the
numbers to round down 742.38 ??????

 

[o;;]

Hi Jimii,

Try:

Int([List Price] * (1 - [Discount]) * [Quantity] * 100) / 100

Clifford Bass

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click
in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get
the
numbers to round down 742.38 ??????

 

[o;;]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get the
numbers to round down 742.38 ??????

 

[o;;]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click
in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get
the
numbers to round down 742.38 ??????

 

[asfsafdsda]

I looked thru a bunch of posts but didnt find what I am looking for.
Table Design
Data Type - Number
Size - Double
Format - Currency
Decimal - 2

Forms
Format - Currency
Decimal - 2

This is an order form, where you have List Price, Discounted Price and
Total,
then shipping and handling gets added in.....The List Price that comes
from
the table is fine, you can click in that field and it shows 2 fixed
decimal.
The other two fields are calculated. So that being said, take a list
price
of 329.95 and a 25% discount which makes it 247.46 which when you click in
the field shows 247.4625 which with a quantity of 3 is 742.39 but when
clicked is 742.3875.

To match our internal system they do not round and I would need to get the
numbers to round down 742.38 ??????

 

[jy]

cgghkjn