Counting using 'build expression'

[01491]

I'm trying to use a textbox on a form that brings the number of records held in an unopened query.
The expression =count([QryName]) does not work.

Can anyone help me?

Thanks

 

[Guest_imported]

Well you could use the DCount Function. You would have to select a field in the query that didn't have nulls, like the Primary Key, and then use this as the ControlSource for the textbox on your form:
=DCount("[FieldNameHere]","[QueryNameHere])
That should do it.
Paul

 

[01491]

That's brill,

Thanks mate!!