In Access field 0.5 becomes 0 and 1.5 becomes 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field looking up a list which includes 0.5, 1.00 and 1.50. When
0.50 is selected, only 0 appears and when 1.50 is selected it shows as 2. I
want to be able to enter from a look-up list or table numbers to 2 decimal
places (I have already set the decimal places formats to two places)
 
What data type is the field? It sounds like you have it set to integer or
long. It needs to be currency, single, or double.
 
Thanks for the response. I originally set it to currency, but you can't use
look-up from a currency field. However, I've changed the data type to
Number, Field Size to Double and Format to Currency and it works. Many
thanks!
Access Enthusiast
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup field is ignoring a value 1
decimal places 5
Found a Bug or Error in Access 2002-2003 Round Function 3
Access stripping decimal places in query 1
Vertical lookup conundrum 4
subtotal function 1
Access database sum calculation error 0
Update Query with subquery with where clause to subquery?! 2

Back
Top