I need access to count the number of records in a report

[MadSlayer]

I need access to give me only total number of records of one kind. so what i want is a number in my report stating the number of records that wpuld be normally fully shown.
Anyone????

 

[Aubs010]

Have a look at this web page, I've just come accross it while looking for something else...It might help!

http://support.microsoft.com/default.aspx?scid=kb;en-us;98790

Aubs

 

[Trendsetter]

If you just need to "count" the number of records in your report then add a textbox to the detail section of your report and set the control source as =1. Then set the running sum to "Over All"
If you are looking to count specific records you need to give more information of your needs

 

[MadSlayer]

Ok, it couynts, but my report is made out of different invoice id's and i want to count the number of order records for 1 company, and now, he keeps counting on. per example first company 19 orders, goes perfect, next company 2 orders, makes the total 21 in stead of 2

Anyone?

 

[Trendsetter]

If you are using Company as a group header then instead of having the running sum set for "Over All" set it to "Over Group" that way it will count the number per Company

 

[danvlas]

A text box with the control source:
=Count(*)
in the report header/footer will do...

Good luck,




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MadSlayer]

yo danvlas, tnx dude, it works