Currency question

[Joe Cilinceon]

I ran into a strange problem. I have a form that takes payments and when
showing the total at the bottom of what is owed it is dropping the change.
For example it shows as $35.50 in the field but then shows $35.00 in the
total field. Now I've checked and all fields are formated for Currency. My
question is this according to what I've read, Access 2002 will default all
integer values to long integer which is what currency would be. In the code
behind it I have it total all the values that could have been paid using
NZ(fieldname here,0) + Nz(next field name,0) etc. What am I missing on this.

 

[Joe Cilinceon]

NEVER mind DUH I figured it out, had the Function doing the math
deminisioned as an Integer.

 

[John Vinson]

NEVER mind DUH I figured it out, had the Function doing the math
deminisioned as an Integer.

Make sure the table Fields are of Currency datatype as well. There is
a Currency *format* but applying it to a Long Integer number field
does not change the fact that the field accepts only integers.

John W. Vinson[MVP]

 

[Joe Cilinceon]

The underlying tables are all Currency. I have a function that keeps the
totals correct on any change on the form. This is where I had it declared
and Integer. Thanks John.