By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 1,134 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Entering dates as dates-not text

P: 2
Hello,
I am a student who has developed at database for the Pioneer Cemetery that adjoins our school. I am very inexperienced with Access. I use an input mask to add burial dates mm/dd/yyyy. The information is sometimes incomplete; we may have just a year or month. I can't seem to make the entries dates instead of just text. I would like to be able to make queries that would generate reports such as all those who died during the influenza or TB outbreak or in chronological order. I only know how to write the most basic queries.

Any assistance would be greatly appreciated.

CB Cemetery
Mar 9 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,349
An input mask doesn't change the data type, you'll have to change the data type of the field itself to Date/Time
Mar 9 '07 #2

P: 2
An input mask doesn't change the data type, you'll have to change the data type of the field itself to Date/Time
I should have mentioned that I do t set the format property to short date. The problem is that if I save the changes, any dates that are not complete (only a year or month and year only) are deleted for the save to take place.

Could I set Format property up differtly?

Thanks
Mar 9 '07 #3

NeoPa
Expert Mod 15k+
P: 31,347
I should have mentioned that I do t set the format property to short date. The problem is that if I save the changes, any dates that are not complete (only a year or month and year only) are deleted for the save to take place.
That would certainly come under the heading Relevant Info :D
This is a little complicated as a month is not a Date per se. If you can live with the first day of a month representing a month and 1 Jan representing a year with no date specified, then just convert any entered date to a valid date that way.
Otherwise, not too surprisingly, if you don't have a date - you can't store it as a date.
If you can't use dates then you may want to consider storing the data in three separate fields (Day; Month; Year). This will make searching and grouping a little more involved. At the end of the day you can't ask Access to guess what you want in your searches. If you can't supply it the information you want, then it can't provide the answer.
Mar 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.