Default Value in Access

  pinno 12:26 22 May 06
Locked

Hi I'm new to Access and i'm trying to compile a database for recording Engineering Incidents at work,
So what i'm trying to do is to have a field automatically update to whatever shift it is at that time when a new report is generated.
i.e.
from 07:00 to 14:00 the default value for ther field would be Days ;14:00 to 22:00 would be noons and 22:00 to 07:00 would be nights.
In the table the field is named Shift.
any help would be welcome

thanks
Pinno

  pinno 01:35 24 May 06

anyone able to help?

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…