regarding count()

[cnuhima]

Hi guys,

I want to get the count of the records in the report..How can i get it..

Please help me out..

Thank you

With regards,
HimaBindu

 

[Steve R.]

Hi guys,

I want to get the count of the records in the report..How can i get it..

Please help me out..

Thank you

With regards,
HimaBindu

lonRecordCount = DCount("[Representative]", "SiteInspRptQry", "[Representative] LIKE '*" & [strFieldRepresentative] & "*'")

This counts the number of times a Representative appears in a Query(SiteInspRptQRY) that is used to generate a report. Before using, I would suggest looking at what Access HELP has on how to use COUNT.

 

[cnuhima]

Sorry,I am not able to get it..Please help me out...

Thanks
HimaBindu

 

[Steve R.]

Sorry,I am not able to get it..Please help me out...

Thanks
HimaBindu

You will need to read the COUNT topic in Access HELP. Also you should have at least one book on on VBA programming for Access.

 

[Brianwarnock]

I agree with Steve that you should read the help on Count, but it won't solve all your problems.

In your situation I'm guessing that you need to place an unbound textbox in the report footer with control source =Count(*)

brian

 

[cnuhima]

Thank you guys..

I was not not able to get it when i Keep the count(*) in report footer..But i got it when i replaced it to header..

I donot know the reasons behind it..but i got it..

Thank you,
HimaBindu