I have a database that keeps track of employees absences and tardies but after a certain amount of time is the data valid. I want to be able to type into my text box a date and have the query collect all infromation a year back. I know how to do it if I was just using the current date but how do I pull the information from a date a user can input?

In the date field I have the following:
=[form]![selectdate]![date]< 365
I've even tried [form]![select]![date] - 365

Can someone help me out? :)

Use the between function in the criteria field of your date.

Between forms!selectdate.date - 365 And forms!selectdate.Date

Although, Date is a reserved word, and I'm not sure can call a control Date. You might want to think about changing the name.

Thank You Very Much For Your Help