MS Access 2007 Form
Hi All
I am creating a MS Access 2007 database. I’m hoping someone could help me with this.
I have a date of birth field. If we are not able to acquire the date of birth then we are to enter 99/99/99. Is there a way to allow only dates and 99/99/99 in to the date of birth field?
Thanks in advance.
I am creating a MS Access 2007 database. I’m hoping someone could help me with this.
I have a date of birth field. If we are not able to acquire the date of birth then we are to enter 99/99/99. Is there a way to allow only dates and 99/99/99 in to the date of birth field?
Thanks in advance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No points, please.
I agree with all of the above. Leave the field blank (NULL) if it is unknown (after all, that is what a NULL represents). Then use gustav's technique of formatting that NULL to "99/99/99" when you do your export to Excel.
I agree with all of the above. Leave the field blank (NULL) if it is unknown (after all, that is what a NULL represents). Then use gustav's technique of formatting that NULL to "99/99/99" when you do your export to Excel.
ASKER
Yes I agree "another system" is bad.<br />I work for a local government and we collect date for the federal government. With Access we could create databases on the fly and get the data to the feds quickly. It’s the best we can do for now.<br /><br />cactus_data, I really like your suggestion. This is very useful for other fields in my database. The fed’s do not want blank data fields in their .dat file. At the same time there won’t be a need to train users on what to enter if the data is not available. Now I will not need to clean-up the data after running an excel query. I’ll let Access do all the work for me. You make my job enjoyable again!<br /><br />Thanks!!!
Thanks. You are welcome!
/gustav
/gustav
ASKER
We are collecting data that will be extracted into excel and converted into a .dat file. The .dat will be uploaded into another system and 99/99/99, in that system, represents unknown or not stated. I know I could make the changes in excel but, I'm just thinking less work for me. I really like mbizup suggestion to format the field. I will close this question tomorrow just in case someone suggest something else.
Thanks