Counting Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 15 Jul 2005 23:19 GMT

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

Signature

Greg

Reply to this Message

Marshall Barton - 16 Jul 2005 17:29 GMT

>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
[quoted text clipped - 4 lines]
>="Summary for " & " " & [Crew Leader] & " (" & Count(*) & " " &
>IIf(Count(*)=1,"detail record","detail records") & ")"

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") & ")"

Signature

Marsh
MVP [MS Access]

Reply to this Message

Greg - 25 Jul 2005 17:46 GMT

I tried to do this and it consecutively numbers the Groups and does not count
the number of records.
Any other Ideas?

Signature

Greg

> >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
[quoted text clipped - 16 lines]
> ="Summary for " & [Crew Leader] & " (" & InspCnt &
> " detail record" & IIf(InspCnt = 1, "", "s") & ")"

Reply to this Message

Marshall Barton - 25 Jul 2005 19:22 GMT

>I tried to do this and it consecutively numbers the Groups and does not count
>the number of records.
>Any other Ideas?

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Greg - 26 Jul 2005 00:07 GMT

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") & ")"

Signature

Greg

> >I tried to do this and it consecutively numbers the Groups and does not count
> >the number of records.
[quoted text clipped - 5 lines]
> of the report's output and show what it is that you want to
> number.

Reply to this Message

Marshall Barton - 26 Jul 2005 16:56 GMT

>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
[quoted text clipped - 5 lines]
>="Summary for " & " " & [Superintendent] & " (" & Count(*) & " " &
>IIf(Count(*)=1,"Item Inspected","Items Inspected") & ")"

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?

Signature

Marsh
MVP [MS Access]

Reply to this Message