Count # of records from a query and show it in a report.

[brunces]

Fellas,

Please, can anybody tell me how to create an expression, inside a textbox in a report, to count the number of records in a query?

Detail: This query has no link to the report.

I don't wanna use VB. But, if there's no other way, how could I do that using VB and showin the result in a textbox in the report?

Thanx a lot for the attention.

Hugz,

Bruno
brunomag@ftml.net

 

[theprez]

Try using the dcount command as the datasource for the text field. Here is an example

=DCount("*", "QueryName")

 

[brunces]

theprez,

Thanx, my friend. It worked very well.

Bruno