Discussion:
Rounding down or not at all in Forms
(too old to reply)
JimiiZ via AccessMonster.com
2009-08-25 20:52:17 UTC
Permalink
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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
Clifford Bass
2009-08-28 18:18:01 UTC
Permalink
Hi Jimii,

Try:

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

Clifford Bass
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
unknown
2009-10-10 13:41:20 UTC
Permalink
Post by Clifford Bass
Hi Jimii,
Int([List Price] * (1 - [Discount]) * [Quantity] * 100) / 100
Clifford Bass
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
unknown
2009-10-10 13:32:58 UTC
Permalink
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
unknown
2009-10-10 13:41:30 UTC
Permalink
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
unknown
2009-10-10 13:38:37 UTC
Permalink
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
unknown
2009-10-10 13:41:26 UTC
Permalink
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
asfsafdsda
2009-10-16 00:27:54 UTC
Permalink
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
jl;jl;jl;jl;jl;j
jy
2009-10-20 09:19:49 UTC
Permalink
cgghkjn
Post by 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 ??????
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200908/1
Continue reading on narkive:
Loading...