true/false or what

[MrBLT]

Hello everyone
for one of my tables i have a event that can happen at day or night. What is the best way to enter this data. Should i use a true/false statement or just enter it as is?
Thanks everyone

 

[a.sinatra]

tblEvents
----------------------------------
DayNightID (number long int) (fk) [many side]

tblDayNight
---------------------------------
DayNightID (autonumber) (pk) [one side]
DayNight (text)

Set up the relationship

You would enter 2 values into DayNight.. "Day" & "Night" an id for each would therefor been generated. Most likely "1" & "2", then these would be plugged into the event. i tried to explain it, it may of not came out right, but do you sorta understand? If not, feel free to ask



________
Herbal Vape

 

[The_Doc_Man]

Going through the suggestion by MrBLT is technically correct, but holy guacamole, it is a two-entry table. Autonumber and a translation table is kinda like, overkill.

Store the single character D or N in the table in a one-character text field.

Whenever you have to display it, put a header of Day/Night over it. Let the readers figure it out.

 

[a.sinatra]

Or you use a field "Night" and in your forms use vb...

Night = -1
Day= 0


________
VAPORIZER REVIEWS

 

[WayneRyan]

BLT,

Just use a date/time stamp =Now() and let Access figure out
if it is AM/PM.

Wayne