Default Value in Access

  pinno 12:26 22 May 06

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.
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


  pinno 01:35 24 May 06

anyone able to help?

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

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5