PD,
Thanks. Ok, is "Query for Inspection Type Report" the name of the query
that the report is based on? If so, it makes sense that Access can't
evaluate the DCount if there is an unevaluated Parameter.
One approach would be to forget the Parameter Query idea altogether, and
instead put an unbound terxtbox on a form which the user can use to
enter the Account Number. Then, in the query, replace the parameter
prompt with a reference to the textbox, using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]
In fact, I would recommmend doing this in any case.
Then, you could further simplify by changing the expression for your Dec
textbox to like this...
=-Sum([Cal]='Dec')
--
Steve Schapel, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13769
PD wrote:
> =DCount("[Cal]","Query for Inspection Type Report","[Cal] = 'Dec'")Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13769