show numbers to two decimal places

thunderstorm

Registered User.
Local time
Today, 08:05
Joined
Jan 16, 2004
Messages
18
im trying to change two of my fields, start time and end time so that they show two decimal places. in design view i changed the properties as shown in the attachment, but it isnt working. what have i done wrong as this should be really simple but i cant fix it!! thanks
 

Attachments

  • problem.jpg
    problem.jpg
    41.9 KB · Views: 167
Change it from "Long Integer" to "Double", but why aren't you using Date/Time instead of Number?
 
Last edited:
I have no idea why you'd want to use numbers instead of a Date/Time field but, with regard to your question, you can't set decimal places to a Long Integer.

You need to change the number to a Single.
 

Users who are viewing this thread

Back
Top Bottom