Urgent! Form won't work out half a day

[MsCrow]

Hello

I have a form, of which part of it works out the costs for labour - see gif attached. The formula in the total field is: =[Labour_Rate]*[Labour_Cost_Days] which is also used in the related queries for reports. Thing is, it doesn't like 0.5 being entered in the days/hours field and doesn't do the sum, I have changed it to be 1 decimal place but it's still not working.

Thanks

Ellie

 

[mohammadagul]

is the field Type set to number. change it to Text or Currency. that shoud do the trick

 

[MsCrow]

you star, thank you so much!