Add/Subtract 2 count records fields two seperate reports into one.

[JMichaelM]

Anyone recall the control syntax to add two count records totals from two seperated reports into another report?

 

[Mark_]

By "Two separated reports", are these both subreports on ONE report?

 

[Ranman256]

use the 2 queries in Rpt1 and Rpt2
combine them in a union query then sum the values

 

[isladogs]

If I understand you correctly you should use DCount for each of the items you need

=DCount("*","table or query name","optional criteria")

 

[JMichaelM]

Report 1. Has a count total field.(=Count (*)
Report 2. Has a coint total field.(=Count (*)
Report 3. Need to add a control to subtract both.

 

[JMichaelM]

Not subreports.

 

[isladogs]

The Count(*) only works for counting the records in a report whilst it is open.
So you need to count the underlying data using the record source used for each report.
In other words look at the suggestions already provided.

 

[JMichaelM]

Ok. Didnt think it would be that easy. Thanks.

 

[JMichaelM]

The Dcount solution worked..thanks..glorious.

 

[JMichaelM]

Completed the line of work for report. Cant thank you enough. I know its basic but i have to go through the process and build it out so i can then maybe translate it into a better solution using VBA. You are all great and cant thank you enough.

 

[JMichaelM]

Solution..create blank report

1. Text box control. =DCount("*,"qry1") Name: Box 1
2.Text box control. =DCount("*,"qry2") Name: Box 2
3. Text box control. =[Box1]-[Box2] Name: Box3
4. Text box control. =[Box3]/[Box1] Name: Box 5
5. Convert Box 5 to percent.

 

[isladogs]

Solution..create blank report

1. Text box control. =DCount("*,"qry1") Name: Box 1
2.Text box control. =DCount("*,"qry1") Name: Box 2
3. Text box control. =[Box1]-[Box2] Name: Box3
4. Text box control. =[Box3]/[Box1] Name: Box 5
5. Convert Box 5 to percent.

You can do that in one step in a single textbox

=(DCount("*,"qry1") - DCount("*,"qry1"))/DCount("*,"qry1")

Format the textbox control as Percent

OR convert to % like this - format as General Number this time

=100*(DCount("*,"qry1") - DCount("*,"qry1"))/DCount("*,"qry1") & "%"

 

[JMichaelM]

I needed to display the stats but that is very helpful.