>I have a attendance table that goes with an Enrollment table>
>
>I have attendance records for every Sunday> I would like to prompt for a Date and only return the attendance for that date. Is there a way to utilize the Data Enviornment and change the Filter prior to displaying the grid for attendance.
>
>Thanks
>Greg


You need to design a parameterized view that returns only the records that you want to see, depending on a parameter.

CREATE SQL VIEW OneDayAttendance AS SELECT * FROM Attendance WHERE AttendDate = ?ldDate

Then you can set ldDate to whatever date you want, and REQUERY the view.