Query to provide data based on user access level.

[nrugado]

I have a table that has attendance records in it. At this point managers can go in and modify a record from a year ago. We want to lock this down to absences within the last week for management and all records for HR. I have an existing form that uses a date listbox. I am thinking that I can put some criteria in the qry to pull a date range for a manager level and all dates for HR level. Does anyone have any ideas on how to accomplish this in the query. I was trying something along these lines...for the criteria in the date field for the date listbox.

Switch([Forms]![FRM_Security]![SecurityRank]=1,Between Date()-7 And Date(),[Forms]![FRM_Security]![SecurityRank]=2,Date())