Capturing Decimal Values in Variable - Losing decimals when summin
 

I have a variable, "Current", that sums various dollar values from a range
based on certain criteria. However, when I report the total value of
"Current", I get a value that has been rounded. Where I expected to receive
243.25, I get 243.00

What do I need to do to capture the actual value?

Current is declared as Long

Capturing Decimal Values in Variable - Losing decimals when summin
 

Another board gave me the answer.

The sum is a currency, so

Dim Current as Currency is an option, as is
Dim current as Double

"Mark" wrote:

I have a variable, "Current", that sums various dollar values from a range
based on certain criteria. However, when I report the total value of
"Current", I get a value that has been rounded. Where I expected to receive
243.25, I get 243.00

What do I need to do to capture the actual value?

Current is declared as Long