Hi,
I have a simple project to work on and I need some help.
In a field for date/time, I want to have a default value of No Shipment Date, this text for a date/time field.
I appreciate your help
Thanks,
Memento
How to place a text default value on date/time field
Novice
Windows 7 64bit 
Access 2010 64bit
Hi,
I have a simple project to work on and I need some help.
In a field for date/time, I want to have a default value of No Shipment Date, this text for a date/time field.
I appreciate your help
Thanks,
Memento
VIP
Windows 7 64bit Access 2010 32bit
Can't have text in a Date/Time field. Date/Time field is really storing a number. If there is no date then leave the field Null.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
June7, thanks
Subtracting a date/time field from a number to get date/time
Field to display last Friday's date by default
Posting Permissions
Reply With Quote