A
Aaron Neunz
I am designing an Access report. The control source for my report is a
query with four columns of data.
Two columns PRECNAME and PRECCODE may have duplicate records, all of which I
need to appear on my report are doing so just fine.
I have created an invisible text box with a control source =1 in the
details section and another visible text box in my group footer section
with the control source of that text box. However I only would like a count
of the total number of DISTINCT records in each group. How can I accomplish
this?
query with four columns of data.
Two columns PRECNAME and PRECCODE may have duplicate records, all of which I
need to appear on my report are doing so just fine.
I have created an invisible text box with a control source =1 in the
details section and another visible text box in my group footer section
with the control source of that text box. However I only would like a count
of the total number of DISTINCT records in each group. How can I accomplish
this?