I need to be able to count subtotals on a report and was able to do this by having a detail query and a summary query. But then I had to have 2 reports one showing the detail records and their calculations and one for the summary. I would like to be able to do this in one report. I had tried using Dcount on the subtotal query in the detail report in a subsection footer but it is still showing me the count of the detail records. Here is some of the fields in my queries that I am working with....
Query 1 (pulling data all data except for last column) from Transactions Table and last column is from Product Master Table linked on Item No
ID
DATE
LAST NAME
WORK AREA
ITEM NO (with 2 parameters for user to key in specific item no up to 2 items no)
LOT NO
TOTAL PROCESS TIME (calc. in query from related time fields)
QUANTITY
PROCESS
NO OF BEDS
Query 2: (pulls data from query 1)
PROCESS (group by)
LOT NO (group by)
SUM OF TOTAL PROCESS TIME (sum)
SUM OF PROCESS QUANTITY (sum)
The detail report is grouping by Process (header and footer set to yes) and then by Lot No (header and footer set to yes). It has calculations for the total in the LOT NO footer for PROCESS TIME AND QUANTITY.
I would like to have a count on the LOT NO subtotals in the PROCESS SECTION but I get a parameter error when I run the report. Another thing I tried is DCOUNT but I am unable to get that working correctly also.
I was able to get this count in a report running from the summary query but would like the info on one report. I am not sure if a sub report is needed here and how exactly to do it or if there is an equation that will work on the detail report.