Sub Report to Main Report

[mromberg]

Hi all,

I have a simple sub report that brings back product names and a count of records.



Product 1 49
Product 2 76
TOTAL 125

I have no trouble bringing back the total of 125 to my main report for calculations (=[qry_no ship date subreport].Report.Text4) but i also want to bring in the values for each product. Cant figure out how to do that.

Any help is much appreciated!

[pbaldy]

I don't understand. It sounds like you're duplicating what's in the subreport. The total I understand, but the detail is already displayed, so why duplicate it?

[mromberg]

I need the individual product numbers in my main report for other calculations...not the total of the two products. Sure I can display the number which i am doing in the sub report but I need to create some mathematical formulas based on results from the main report and the sub report,(by product). And thanks for taking an interest in my problem!

[pbaldy]

Is it feasible to do them in the subreport? It would seem more logical there. Failing that, you're probably looking at DLookup() to get a specific value from the subreport.