DCOUNT issues

[83dons]

Hi I have a form that is linked to a query by its Record Source.



In one of the Text boxes I want to appear the number of rows in the query where Days = 4 so I thought I would try to use DCOUNT as the Control Source for the Text Box. However every expression I try for DCOUNT throws back error? or name?. Any ideas if this can work and how to sort my code? Iv tried all manner of brackets, apostraphes and inverted commas!

=DCount("[EPISODEUNIQUEKEY]","1-12 Show Records by Date Range","[Days] = '4'")

[ranman256]

The table/qry part, if it has spaces, must have brackets around the name.

[83dons]

I have tried that and no success. I think the problem is that the original query requires start and end date parameters entered when the form opens so maybe DCOUNT will not work...Another solution probably required!

[orange]

It is difficult for readers to guess at what you want in detail. As has been said, any names with embedded spaces require a leading [ and a trailing ] (that's what access needs for syntax)
We know nothing about your tables or fields, or even the details of the issue. Can you tell us in plain English?
Can you post a screen capture of your tables and relationships (relationships window).