hi guys.. has anyone knows hows to set time properly data type in table not using Text data type?
im creating time based on timetable.. is it possible i set the time format like this on access 2007?
Time format:
8:00 AM-9:00 AM
9:00 AM-9:30 AM
10:00 AM-10:30 AM
10:30 AM-11:00 AM
11:00 AM-12:00 PM
2:00 PM-2:30 PM
2:30 PM-3:00 PM
3:00 PM-3:30 PM
3:30 PM-4:00 PM
4:00 PM-4:30 PM
Reasons i want to set these time format on access 2007 is when im creating forms under combo box selecting TIME for timetable class.
help me how to set this data type..
Thanks
Attachment 11409