Report with running totals limited by query results

[kellter]

Greetings,

I have a created a database at work for employee time management. I apologize for being a newbie but what I have created so far works as far as entering employee time off and time accrued. My problem is I have a report based on a query that runs between dates which supervisors use for a monthly audit. All bureaus have no problem using this report to audit employee time off except for one supervisor. He is used to the old DOS based program that shows the balance of time off as of the first date entered in the query and an end balance totaling all time off and time accrued.
My problem is once I limit the report to the dates entered in the query, I have no way of showing the starting balance and the end balance as the data is limited to the query output.
If someone could point me in the right direction theory wise such as using filters or sub queries I will be glad to dive in and research head first.

Your forum has proved Extremely helpful in all my Access endeavors and wanted to say thank you.

 

[dhookom]

While a report is limited to a single Record Source, you can pull in data from other tables/queries using subreports, code, combo boxes, etc. Also, if you could create a query that results in one record per employee with the "balance of time off as of the first date entered in the query" you could add this query to your report's record source and join the employee PK fields. This would make the "balance ..." available in your report.

Duane
Hook'D on Access
MS Access MVP