I'm using Access 2003.
I have a table; pretty basic to capture the number of hours personnel work in a given week.
The 'hours' field is given me the pip. Details of the field:
Data Type: number
Field size: long integer (although I've also tried integer and decimal)
Format: standard (although, again, I've also tried general number and fixed)
Decimal places: 2
I want to enter hours as a decimal amount; ie 1.5 hours not 90 minutes and not 1 hour 30 minutes. At the moment (regardless of which combination of the above formats I use) I can not get it to show me the 0.5 or 0.25 etc. If I type "11.5" I either get 12.00 or 11.00 (can't seem to see a pattern as to which way it rounds). So, it is showing the decimal places, but not their values.
I have a table; pretty basic to capture the number of hours personnel work in a given week.
The 'hours' field is given me the pip. Details of the field:
Data Type: number
Field size: long integer (although I've also tried integer and decimal)
Format: standard (although, again, I've also tried general number and fixed)
Decimal places: 2
I want to enter hours as a decimal amount; ie 1.5 hours not 90 minutes and not 1 hour 30 minutes. At the moment (regardless of which combination of the above formats I use) I can not get it to show me the 0.5 or 0.25 etc. If I type "11.5" I either get 12.00 or 11.00 (can't seem to see a pattern as to which way it rounds). So, it is showing the decimal places, but not their values.