Assign star sign to date entered

[doctorswamp]

Hi

Want to be able to enter a birthdate into a form then get the star sign returned in an another field. Also allow an anniversary to be identified for this date.

So, enter say 14/9/46 as birthday, identify this as 'Virgo' in next field.

Then separately be able to query the database for anniversaries falling due in a particular month, so query say 'September' and get all records for birthdates from 1/9 to 30/9.

Thanks to all you dedicated helpers!

 

[Nareik]

Are you using word, Access, Excel.

If access/excel I would suggest you create a list of all the possible dates in a year (only 366) do a lookup based on the day/month.
If you are in word, I can't suggest anything off-hand other thtn use access/excel.