469,271 Members | 1,452 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Count Records Retreived on a Report

I have been trying to find a code that will help me display at the bottom of the report the number of records that where retrived for the report.
Nov 7 '06 #1
2 2599
I have been trying to find a code that will help me display at the bottom of the report the number of records that where retrived for the report.
For some reason I tried using the =count("*") code on the footer and for some reason it didn't work. As I was messing around with it, I accidentally moved it over to the header and it worked just fine. Can anyone tell me why it wouldn't work on the footer?
Thanks,
Nov 7 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
I have been trying to find a code that will help me display at the bottom of the report the number of records that where retrived for the report.
Pick one of the fields from your detail section. For this example I am using FieldID.

Set the control source of an unbound textbox in the footer to:

=Count([FieldID])
Nov 7 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Hugo L. | last post: by
2 posts views Thread by wilscott1st | last post: by
22 posts views Thread by MP | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.