Formatting amounts

[jllcpa]

I'm trying to build a database to track multiple invoices on projects but the tables always rounds the amounts - what do I do to have it show the unrounded amounts?

[davegri]

You probably have the amount fields in the table defined as long integers. Change to currency.

[jllcpa]

Currency is not an option for field size and I have currency as the format.

[davegri]

Currency is not an option for field size and I have currency as the format.

Don't understand about field size.
Are the rounded amounts in calculated fields?
Are the rounded amounts actually in the table, or showing up in a form as rounded?
Rounded how? To no decimals or ???
Please show the calculations and the data types of all the fields involved in the calculations.

[jllcpa]

They are not calculated fields - they are input fields.

They are rounded to the whole number with decimal .00

The calculation field also rounds - I have changed the field type to currency in the calculation field.

[davegri]

I suggest using Decimal and specify scale and precision properties in the table.
Precision is the total number of digits in a number, including left and right of the decimal.
Scale is the number of digits allowed to the right of the decimal.

So 1234567.89 has a precision of 9.
A precision of 4 and scale of 2 would result in a number with a maximun value of 99.99
123456.789 has a scale of 3 and precision of 9.
Precision has a maximum value of 28, but textboxes in forms allow only a max of 15 decimal places.

If problem persists, please post DB with the data entry form and table the data is stored in so that we can see the problem in action

[jllcpa]

That did the trick - thank you very much for your help

[davegri]

Glad to help. We made quick work of that one!