Time field

[Gareth]

I have a time field into which I need to enter values of more than 24:00

Is there any way to format the field to allow this?

Thanks in advance.

Gareth

PS
I am new to Access!!

 

[Jeff Boyce]

Gareth

I have a time field

Do you mean you have a table field of type Date/Time?

into which I need to enter values of more than 24:00

If this is an Access Date/Time field, it stores "point-in-time" data, not
"duration", as your statement suggests.

Is there any way to format the field to allow this?

You cannot format a Date/Time field to store something it can't hold. You
could use a numeric data type field to store a "number of hours", another to
store a "number of minutes", and a query to concatenate the two together.
Alternatively, you could use a single numeric field and store total minutes,
and use a query to parse that into hours & minutes.

Good luck

Jeff Boyce
<Access MVP>