Can I sum a count from the subreport to show on the main report?

[tafnuef1]

Ok I have a subreport... I have a Count called "AccessTotalsPrepper Error". I am counting the number of errors found in a batch audit.

So on my main report I know I need to create a textbox to pull that data to sum up the counts. In that text box I have the source code set as
=Sum([Prepper Errors Count Query subreport].[Report]![AccessTotalsPrepper Error]) So far it won't pull the data??? So not sure if my expression is incorrect or if I have it in wrong place.

This is my layout of my report:
Main Report:
Page header: Title of Report

Prepper Name header: (which is my first Grouping by prepper name) There I have just the Prepper Name

Detail: I have Batch Number ID, Date of Audit and Document Count being pulled from a query.
ALSO in here I have my subreport showing.
In the Sub REPORT: I have Prepper Error and Prepper Doctype showing from another query. I have the Prepper Error Counted per Batch Number ID in the subreport.

Prepper Name Footer(main report) here I have counted number of batches and a sum of the document count all in the main report. ALSO currently this is where I am trying to sum the count of prepper errors from the sub report referenced at the top of this post.

Page Footer: Here I just have the Date/time and name of report.

SO where should the SUM of the Prepper Errors from the subreport?? I seriously need help here.

 

[vbaInet]

Are you summing in the subreport footer?

 

[tafnuef1]

I tried that.. put it in every footer but would not work???

 

[vbaInet]

I was only asking not proposing a solution.

Can we see a stripped down version of your db?

 

[tafnuef1]

ok, can you give me an idea of what a stripped down version would be? How does most folks do that. Sorry I am such a newbie!

 

[vbaInet]

This post will help:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587