hi i am trying to do a simple access database, with quantities, and a query with a report
I have create a table with one of the variables being a numeric value, but i need to have 2 decimal places. when i format with 2 decimals, what ever i type in is rounded up. Can anyone help.

Recommended Answers

All 8 Replies

Does the data in your table have 2 decimal places, or did you just set the query and report to display at 2 decimals?

Does the data in your table have 2 decimal places, or did you just set the query and report to display at 2 decimals?

i have 2 decimal places in the form, the table and the query. what happens is that if for example i input 1.34, the figure will show as 1.00, and if i post 1.89 it will show as 2.00.

What data type and field size do you have set in the table? Keep in Mind that some of the field sizes don't allow decimals.

i have tried with fixed, standard and general

In the table you should be looking at either currency or number. The field size should be either decimal, single or double.

Long integer which is the default for number data type, while it will show 2 decimal places if you set it , it cannot actually read them.

Thanks it worked, i used field size as double, format as standard and decimal places as 2.
Since you are so good at this may i ask another question?

Just ask, not sure if I can help, but I'll try.

commented: sorted my issue +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.