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

Yearless birthdates

P: n/a
Folks,

I am trying to create a database for tracking birthdays. Don't have the
birth year for the vast majority of these, just the month and day.

I could create separate fields for the month and the day (and the year for
those that are known), but creating one field is more attractive. I will be
wanting to sort by the birthdays eventually. Is this doable?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I think it would be neater if you still separate the 3 numbers into 3
separate fields and create a query that builds a birthday with month and
day. You then sort the birthdays in the query.

Herbert

"Harry McGuffin" <h.********@comcast.net> bl
news:QApJb.199576$8y1.677184@attbi_s52 g...
Folks,

I am trying to create a database for tracking birthdays. Don't have the
birth year for the vast majority of these, just the month and day.

I could create separate fields for the month and the day (and the year for
those that are known), but creating one field is more attractive. I will be wanting to sort by the birthdays eventually. Is this doable?

Nov 12 '05 #2

P: n/a
Harry,

You could use an update query and set the year for the BDs where you don't have
a year to 1900. Then you could use a Date/Time field to record the BDs. To sort
the BDs by mont you could use the Month function and to sort the BDs in a
specific month you could use the Day function.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Harry McGuffin" <h.********@comcast.net> wrote in message
news:QApJb.199576$8y1.677184@attbi_s52...
Folks,

I am trying to create a database for tracking birthdays. Don't have the
birth year for the vast majority of these, just the month and day.

I could create separate fields for the month and the day (and the year for
those that are known), but creating one field is more attractive. I will be
wanting to sort by the birthdays eventually. Is this doable?

Nov 12 '05 #3

P: n/a
Herb and PC,

Thanks for your input. Decided to use a combination of your suggestions.
Made three fields for each birthday. Set the default entry in year to 1900.
Made a query to sort by the month then the day. Seems to be working OK.
Thanks again.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:8i******************@newsread3.news.atl.earth link.net...
Harry,

You could use an update query and set the year for the BDs where you don't have a year to 1900. Then you could use a Date/Time field to record the BDs. To sort the BDs by mont you could use the Month function and to sort the BDs in a
specific month you could use the Day function.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Harry McGuffin" <h.********@comcast.net> wrote in message
news:QApJb.199576$8y1.677184@attbi_s52...
Folks,

I am trying to create a database for tracking birthdays. Don't have the
birth year for the vast majority of these, just the month and day.

I could create separate fields for the month and the day (and the year for those that are known), but creating one field is more attractive. I will be wanting to sort by the birthdays eventually. Is this doable?


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.