We have a query already that adds up totals from a series of tables and returns only results from the current week. What I need is to have a webpage that passes input fields to a results page that will display results based on the input.For example:
Our current query returns time logged for the current week with each time entry listed:
Date User Description Total Hours
4/11/05 John Doe Emailed Jane 00:30
and also returns total time logged per day:
Date Total Hours
What we want is to be able to input the username (John Doe) and the week ending date into a form and get the same format of results as above, but with the criteria the user has input.
I'm not sure how to accomplish this