Hi all,
I am trying to get one and only one textbox added to the detailed section of a blank report that has been sourced to a query that will give the total count of all issues without having to have all the issues displayed. I know I can group and get totals by displaying all the records, but I just won't this one text box on the detail section. Right now it duplicated all the issues and gives me the correct totals. I have used this as the event code in the text box "=count([qryName]![Issue Name]". I have labelled it "Count Issues"
What it displays is this:
Count Issues 77
Count Issues 77
.
.
.
<repeat 77 times>
Once again I just want it to say once Count Issues 77 and that is all I want on the page and I don't want to hide any fields.
Thanks for your help ... Meteo