Total record count

[anslo]

Hello,

I'm stuck! I can count the number of records shown on a report, but how do I show the total number of records in a database in a footer?

Thanks everyone.

-Andrew

 

[Danny Clarke]

Probably the easiest way is:

Choose a field in the table (your primary key will do) and use the following formula in a text box in the footer:

=Abs(Sum([Your Table].[Your Primary Key]))

Works for me!

 

[imollegen]

Access has a count function. That's the easiest way to go.

 

[EndersG]

In the design view of your report under report footer, create a textbox and in the control source put:
=Str(Count(*)) & " records"