Please Help!!! Counting

[lorenzoaj]

Hello all.

I have been searching the archives all afternoon and have come up empty. I have a form that has multiple command buttons that view different reports. The reports are based on queries. Right now I have a text box with the control source set to
=Count([ASSIGNED NCO]![LAST NAME]). Assigned NCO is the query. I want to be able to count all records ijn the query.

With this I get #Error message.

Next to each command button I want to have the total number of records in each report. I hope this explains it.

AJ

 

[pcs]

you can't use the Count function this way...

to get a count in this way, look in help for DCount.

hth
al

 

[Jerry Stoner]

DCount("*", "[Assigned NCO]")

BTW it is not good to have spaces in your names.

 

[lorenzoaj]

Thank you both very much. This is not my db I am just trying to help make it a little better. I do realize that spaces are not a good idea and I do not use them in mine. Thanks again

AJ