I currently have a database containing a table with the following fields:
signid, sign_typ, changedate and time.
The 'changedate' field is the date on which the star sign changes and becomes 'active' until the next 'changedate' in the table. I am trying to search this field by a date the user enters and display the 'sign_typ'.
I am struggling to get this working and any help would be greatly appreciated.