Counting Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is for an inspection sheet that has 26 questions on it. The
report displays on the counts the number of questions answered where I want
to see the number of inspections. I was wondering if there was some way to
divide the number by 26 and if so how? this is what the control of the report
says:

="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"

Thank you
 
Greg said:
This is for an inspection sheet that has 26 questions on it. The
report displays on the counts the number of questions answered where I want
to see the number of inspections. I was wondering if there was some way to
divide the number by 26 and if so how? this is what the control of the report
says:

="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"
Click to expand...


Use Sorting and Grouping to group on the inspection field.
Select Yes for the Group Footer property.

Add a text box named InspCnt to the group footer. Set its
ControlSource to =1 and RunningSum to Over All.

Now add a text box to the report footer. Set its
ControlSource expression to:

="Summary for " & [Crew Leader] & " (" & InspCnt &
" detail record" & IIf(InspCnt = 1, "", "s") & ")"
 
I tried to do this and it consecutively numbers the Groups and does not count
the number of records.
Any other Ideas?
--
Greg



Marshall Barton said:
Greg said:
This is for an inspection sheet that has 26 questions on it. The
report displays on the counts the number of questions answered where I want
to see the number of inspections. I was wondering if there was some way to
divide the number by 26 and if so how? this is what the control of the report
says:

="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") & ")"
Click to expand...


Use Sorting and Grouping to group on the inspection field.
Select Yes for the Group Footer property.

Add a text box named InspCnt to the group footer. Set its
ControlSource to =1 and RunningSum to Over All.

Now add a text box to the report footer. Set its
ControlSource expression to:

="Summary for " & [Crew Leader] & " (" & InspCnt &
" detail record" & IIf(InspCnt = 1, "", "s") & ")"
Click to expand...
 
Greg said:
I tried to do this and it consecutively numbers the Groups and does not count
the number of records.
Any other Ideas?
Click to expand...


Well, I thought that's what you wanted. I'm sure I have
more ideas, but apparently I don't understand your
situation. Maybe it would help if you would post a sample
of the report's output and show what it is that you want to
number.
 
I have a report that is grouped by Builder first, then by Community. There
are a number of inspections for each builder and that is broken up into
inspections per community. On each inspection there are 26 questions. What is
happening now is that the report is counting the number of questions for the
respective grouping level instead of the number of inspections. This number
would work if i could divide by 26 but I cannot seem to do that.
The control source in the text box that gives me the summary looks like this.
="Summary for " & " " & [Superintendent] & " (" & Count(*) & " " &
IIf(Count(*)=1,"Item Inspected","Items Inspected") & ")"
 
Greg said:
I have a report that is grouped by Builder first, then by Community. There
are a number of inspections for each builder and that is broken up into
inspections per community. On each inspection there are 26 questions. What is
happening now is that the report is counting the number of questions for the
respective grouping level instead of the number of inspections. This number
would work if i could divide by 26 but I cannot seem to do that.
The control source in the text box that gives me the summary looks like this.
="Summary for " & " " & [Superintendent] & " (" & Count(*) & " " &
IIf(Count(*)=1,"Item Inspected","Items Inspected") & ")"
Click to expand...


My suggestion was to add another group level for
inspections.

Did you try that? If you did, what about it didn't do what
you wanted? If you didn't try it, why not?
 
Back
Top