Querying data between two dates and creating a report with that data
I have a project I would like to complete but I am having problems with the behind the scenes stuff. I want to be able to compile a report where I am pulling data from different layouts to complete the report. Here are the parameters;
1. Time range = 05:00 Monday thru 18:00 Friday.
2. Report to be generated automatically and saved as a PDF file.
3. Fields from the "Trouble" Layout are "Site", "Tech" and their "ticketsopened", "Ticketsclosed", "TicketCarryOvers".
4. I would like a talley for each field for each day of the date range with the total talley at the end for each ticket field.
The report could very well be a excel spreadsheet that is created. I just want it automated so I don't have to enter data multiple times.