Record Count in Reports

[sam_antoine]

I have created several reports, but I am faced with what may be a difficult task. I need the report to return the number of records in the "clients list report" footer, like you return the number of pages. Can anyone help, it this possible?

 

[Rich]

=Count(*) as the control source of an unbound textbox

 

[sam_antoine]

Thanks, I tried that but it did not work. I tried

=Count(*)
=Count([ClientID])
=Count[ClientID]

But none of the above worked

 

[IMO]

=DCount("[TheFieldYouWantToCount]","TheTableOrQueryTheReportIsBasedOn")

IMO

 

[sam_antoine]

Thanks, Thanks, Thanks, IMO that worked fine. However is it possible to put Record X to Y of Z per report page. Thank you ever so much your help is greatly appreciated.

 

[IMO]

Yes. Create an unbound TextBox in the detail section of your Report and set the Control Source to =1. Change the Running Sum from 'No' to 'Over All' and the Visible property to 'No'. Create another 2 unbound TextBoxes in the PageFooter of the Report and use Min/Max functions to get the Lowest and Highest values from your textBox on that page page.

IMO

 

[sam_antoine]

I do not understand what you mean from the create min/max function part of your instructions. Greatly appreciated if you could simplify. Thanks very much

 

[IMO]

Put the following in the control source of an Unbound Text Box and place it in the Reports Footer. It should return the highest value from your hidden TextBox for each page in the Report,

=DMax("[YourHiddenTextBox]","YourTable")

and 'DMin' should return the lowest

IMO

 

[sam_antoine]

I have tried the following to get e.g. 1 to 30 of 200 Records but it does not work. Any sggestions

=(DMin("[Count]","ClientContacttbl")) & “ “ & “of” &
(DMax("[Count]","ClientContacttbl")) &
(DCount("[ClientID]","ClientContacttbl") & " " & "Records"))

to

 

[sam_antoine]

Hi IMO, I tried what you suggested but DMin and DMax returns the same values on all pages.

DMin returns 19 for the first and every other page and DMax return 19 on the first and every other page.

However when I make the count textbox visible to check that is is working, everythiny is fine where the count of records is concerned.

Do you have any idea why this is so?

 

[IMO]

I think you'll need to create your report again using the wizard. This time add grouping to the report and then use the "Group Footer" instead of the "Page Footer" for the Min and Max controls.

HTH
IMO

 

[sam_antoine]

Thnks but I tried this before I asked for more help and it didn't work. Itried sorting the data and ading verious things to it but it still didn't work. I will give it a few ours of my time and if it doesn't work, then I will forget it. I don't think it is possible neither, but nothing beats a try

 

[IMO]

Maybe these links will help further

http://support.microsoft.com/default.aspx?scid=kb;en-us;216311&Product=acc2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;210261&Product=acc2000

IMO

 

[WayneRyan]

sam,

Saw this thread, IMOs first link is good. Couldn't resist.

Wayne