Default Value variations?

Joined
May 22, 2006
Messages
1
Reaction score
0
Hi I'm new to Access and at the moment I'm trying to put together a database for an Engineering Incident Report;
Where I am struggling is one field is for Shifts (Days Noons & Nights), I want to try and make it so when a new record opens the [shift] field automatically inputs which shift it is i.e. 07:00 to 14:00 = Days; 14:00 to 22:00 = Noons And 22:00 to 07:00 = Nights.

Any help would be welcome

Thanks

Pinno
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top