Default Value in Access

  pinno 12:26 22 May 2006

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 2006

anyone able to help?

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?