Summarization in Report footer with two types of output from same field

Hello everyone



I am in need of assistance with Microsoft Access. In the reporting function of Access I am trying to have a summarization total of indirect time and direct time based off a Auditor Timesheet form developed. On the report I am able to see both the direct time and the indirect time hours seperate per auditor based on the query that is run to seperate direct and indirect hours and each individual auditor stats.



but the problem I am having is trying to summarize on the report the total direct and indirect hours as a whole.



Please let me know if this a simple solution by building an expression in the field for the report or some type of VBA code input which would suffice?



Thank you

Your Subject says "...two types of output from same field", but you seem to be describing a report that includes two different fields. That's confusing. If there are two fields, you should be able to put two SUM() data sources in the summary (Report Footer) section of your report. If that's not what you want, you'll have to explain more fully what you're trying to do.

thats it exactly the case i have it set up where the field produce two types of output based on the if and condition statement.