Query to search date fields for one date

[JockVSJock]

I work in HR and have created a Access database that shows how many people apply for jobs/positions over 8 days. I do query off of the main table, update data from the query, and then append the main table to update it. But, I would like to create a query that would show me all of the jobs for a certain day, for example 9/27/2001 and show the number of people that have applied for that position on that date.

I'm guessing that the date would be a primary key, but remember that I keep track over 8 days, and on my master table I have 8 colums that are dedicated to the 1st date, 2nd date, 3rd date, and so on and so forth.

thanks,

 

[tempclerk]

Create a form with a textbox control named txtSearchDate. In your query design view, for each of your date columns in successive criteria rows put Forms![YourFormName]![txtSearchDate].