I have an Access 2003 database and a set of ASP pages.
The database contains very basic information consisting of first and last
names and 1-10 dates.
I would like to create a query in ASP or inside of Access that I can use the
SQL from to call data from the webpage that allows the user to search one
date and find all instances of that date in all records.
Field names in Access: LunchDutyDate1, LunchDutyDate2, LunchDutyDate3...etc.
User searches for 10/1/2004
This value could appear in multiple records, but in different fields. User
ID 1 could ...