Still working on the benefit time app. the following code works to populate a detailsview control based on a specified StaffMemberID:
SELECT VacationEarned-VacationUsed [Vacation Left],
PersonalEarned-PersonalUsed [Personal Left],
SickEarned-SickUsed [Sick Left]
SUM(VacationEarned) VacationEarned ,
Now I need to do the same thing only have it based upon my StaffMemberNameDropdownLis
t selected value.
As always, thank you for your help