Zodiac sign on PersonF - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Zodiac sign on PersonF

Bj Schroeder

3 years ago

Dear Fleet Admiral, I enjoy all your Fast Tips videos. I have been working on a personal database with Birth dates in it. I thought it would be interesting to have Zodiac signs on the Person Form when the Birth date is put in. I don't need to store the zodiac sign in the record, but thought it would be fun. How could I go about making this happen?

BJ

	Alex Hedley @Reply 3 years ago
Could keep a static list or another Table with the start and end dates, then do a DLookup

	Richard Rost @Reply 3 years ago
What a crazy coincidence... I just got an email from another member asking how to do the same thing. I was going to make a video about it. Stay tuned.

	Kevin Robertson @Reply 3 years ago
I just built this for fun. Not too difficult. I look forward to the video though.

	Alex Hedley @Reply 3 years ago
Did you include the 13th?

	Kevin Robertson @Reply 3 years ago
13th? Has another sign been added that no-one told me about?

	Richard Rost @Reply 3 years ago
Video is ready. And yes, I talk about the 13th constellation (Ophiuchus). Zodiac. Public release date is Tuesday, so BJ, if you don't want to wait until then, JOIN as at least a Silver member.

	Bj Schroeder OP @Reply 3 years ago
Very helpful. Thanks to all!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View