Info from queries in text boxes

[Desmondo]

I have a form with text boxes that I would like to display vital stats from various queries not related to the form and have tried several ways to do it without success and am sure it must be something quite simple. Currently I am trying to use count in the control source of a text box to extract the info from a query not linked to the form. One example is I have a query with dates in it and would like to display how many records have dates <now(). Any help or suggestions on the best way to do this is appreciated, I have used access for a couple of years for simple tasks and now trying to get more in depth so my apologies if this is primary school stuff, we all have to start somewhere

[pbaldy]

Try DCount() in the textbox.

[Desmondo]

That did it.... thanks for the fast response. I had tried this and must have had the formatting wrong. How do I add/format <now() to save having a separate query just for this. I have tried various ways and now have =DCount("fieldname1","queryname",["fieldname1"<now()]) what have I got wrong ? Cheers.
I worked it out =DCount("fieldname1","queryname","fieldname1<now() ") just a formatting issue. Thanks

[InsuranceGuy]

Dcount("[fieldname1]","[queryname]","[fieldname]<now()")

[pbaldy]

Happy to help!