stupid report problem

[Guest]

I have a very basic question, any suggestions would be
greatly appreciated.

I added a text box to the report footer. I want to count
the total number of records in the report. I have messed
around with the dcount funtion and I am sure I dont have
the syntax correct. I am trying to use the dcount
function from the control source line in the properties
of the text box. I have been able to create a simple
query which give me the total, but now I dont know how to
call the query from the report.

Any suggestions would be great....thanks.

bob

 

[Marshall Barton]

I have a very basic question, any suggestions would be
greatly appreciated.

I added a text box to the report footer. I want to count
the total number of records in the report. I have messed
around with the dcount funtion and I am sure I dont have
the syntax correct. I am trying to use the dcount
function from the control source line in the properties
of the text box. I have been able to create a simple
query which give me the total, but now I dont know how to
call the query from the report.

Rasier to use the expression:

=Count(*)

 

[fredg]

I have a very basic question, any suggestions would be
greatly appreciated.

I added a text box to the report footer. I want to count
the total number of records in the report. I have messed
around with the dcount funtion and I am sure I dont have
the syntax correct. I am trying to use the dcount
function from the control source line in the properties
of the text box. I have been able to create a simple
query which give me the total, but now I dont know how to
call the query from the report.

Any suggestions would be great....thanks.

bob

If all you wish to know is the number of records in the whole report,
all you need, in the control source of an Unbound Control anywhere in
the Report EXCEPT in the Page Header or Page Footer, is:
=Count(*)

You can use DCount() referencing a query.
The syntax is the same as for a table.
=DCount("*","QueryName")

or, to limit the count to certain records ....
=DCount("*","QueryName","[SomeTextField] = 'New York'")