Have a date field called "Date paid" or similar.
Then, if you must have a field with a yes or no in it, make it be a
calculated field based on whether there is a date in the Date Paid field.
But in my experience there is no need for such a "yes" or "no" field to
indicate payment. The Date Paid field is plenty good enough for every need.
I have a search as follows:
datPrimaryRS.RecordSource = "select * from 1033s where Date like'*" &
Text2.Text & "*'"
Text2.Text contains the dat to search for (11/02/85) which works fine,
however I am trying to list all entries on the database on that date and
before that date.
Thanks in advance!