Adding decimal number to MS Access query

Question

I have a Completed field in Access that is a number data type. The number in this field is 1 for all records unless the record has a status of "Cancelled". In this case the number is to 0.5.

However, when I input the 0.5 value, Access rounds the number to 0. I tried updating the format to Format([Table].[Field Name]),"Fixed"), but the values of 0 and 1 continue to show, not 0.5.

How can I get the 0.5 to show in the field?

What number size - Integer, Double, Long Integer? Make sure it is Double. Or use a Yes/No field. Or even more informative would be date/time CompletionDate. Why 0.5 for False? — June7
– June7, Commented Sep 1, 2021 at 17:13
Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Sep 5, 2021 at 10:14

Gustav · Accepted Answer · 2021-09-01 17:12:35Z

1

How can I get the 0.5 to show in the field?

Change the data type of the field from Integer or Long to Double.

answered Sep 1, 2021 at 17:12

Gustav

56.3k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding decimal number to MS Access query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related