Textbox Query Count

[hatstand]

Hi All,

A simple problem (I hope) a that is driving me crazy. I am trying to return the record count of a query into a form using a Textbox. I have tried '=Count([Qry_New_Feed_Names]![Feed_Name])' in the control source yet it gives a #Error . Using the same Expression in a query returns the result. Am I missing the obvious?

 

[xenou]

Hi I think you will have to give more information. I'm not sure what you are trying to count. Also this is not a query so I'm not sure why it would work in a query. Normally a DCount() function would be used here.

 

[hatstand]

Hi,

I have a query that has one field where new 'feeds' are shown. So the field might have 'cat, dog, cow' as they are new to the database. I want to show how many new 'feeds' there are by counting them. So the Textbox would return '3'. I can recall doing this before, but dammed if I can remember how to do it.

 

[xenou]

Hi,
you would use DCount for this, probably:
=DCount([FieldName],[QryName])

 

[hatstand]

That did it, I just replaced the '[' with '"'. Thanks for your, very much appreciated.