thank you guys for responding; the parameters passed in by the user are from the form, selecting the employee name and selecting a date. then what I wanted to do was, based upon the selected employee and date, retreive the data for the week start up until the selected date, and sum them up... I...
hi all... i am trying to grab rows based on two user-inputted criteria, 'theEmpID' and 'theDate'..and then, based on 'theDate' value, 'startDate' will be used as the criteria for the beginning date range up until the ending date range of 'theDate'
SELECT *
FROM [salesQuery]
WHERE emp_id...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.