are there limitations to dcount

[MelissaHoo]

I have a dcount giving an #error.

=DCount("[PO#]","q report"," [o washed]=0 ")

q report is a query based on another query with some criteria (and some tables joined). [o washed] is a boolean field.

I set up a test where I query a query and the dcount works.

Any ideas?

Thanks

 

[PHV]

Perhaps this ?
=DCount("[PO#]","[q report]","[o washed]=0")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Remou]

It works fine for me. Have you checked all the names?

 

[MelissaHoo]

I have cut and pasted the names and also tried other fields (like counting a non-boolean). I have the same expression based on another query and it works. I think there is something different about "q report".