univinus
07-18-2004, 03:15 AM
I'm fairly new to Access 2003, so apologies if this is a daft question.
In the design view of a new table i'm creating, i'm trying to set my TimeSlot field to ddd hh:nn format. For example, "Mon 21:30".
However, when I actually try to enter a date in the table, I get an error saying that it doesn't follow the format of the field. The same goes for entering a default value for the field back in Design View.
Help me please!
In the design view of a new table i'm creating, i'm trying to set my TimeSlot field to ddd hh:nn format. For example, "Mon 21:30".
However, when I actually try to enter a date in the table, I get an error saying that it doesn't follow the format of the field. The same goes for entering a default value for the field back in Design View.
Help me please!