Number the line

[Rod]

How can I have a report number the line of so I can easily see how many
record met the criteria in the detail?

Thanks.

 

[Rick Brandt]

How can I have a report number the line of so I can easily see how
many record met the criteria in the detail?

Thanks.

Add a TextBox with a control source of =1 and set RunningSum to "Over all".

You could also just use =Count(*) in the Report Header or Footer to see the
total count.

 

[fredg]

How can I have a report number the line of so I can easily see how many
record met the criteria in the detail?

Thanks.

To number detail lines, add an unbound control to the detail section.
Set it's control source to
=1
Set it's Running Sum property to Over All

 

[Steve]

Excuse me if this is a smart answer but the answer to your question is:
"They All Did"

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Rick Brandt]

Steve wrote:
Excuse me if this is a smart answer but the answer to your question
is: "They All Did"

"They All Did" is an answer to the question "Which Records?", but it is not
an answer to the question "How Many Records?" which is what the OP asked
for.

 

[Steve]

Rick,

Lighten up, it was meant as a joke. But by the way, "All" is a quantity and
therefore does answer the question "How Many Records?"

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Keith Wilby]

Rick,

Lighten up, it was meant as a joke.

Yeh, right.

But by the way, "All" is a quantity and therefore does answer the question
"How Many Records?"

Have you ever considered becoming a barrister? They often have to defend
the indefensible and you're an expert.