C
cbTear
I have a field in a report that uses a query called
"qryMPV_DateRange_SelectNurses_FromForm" in the dcount function.
I am using the dcount function in may different reports; with different
query names. Is there a way to tell dcount to use the query that is the
record source of the report? or do I have to repeat this query name in the
dcount function everytime it is used?
Text box Field example
=DCount("[II6]","qryMPV_DateRange_SelectNurses_FromForm","[II6]>0 and
[II6]<3 ")
Thanks for any ideas, CB
"qryMPV_DateRange_SelectNurses_FromForm" in the dcount function.
I am using the dcount function in may different reports; with different
query names. Is there a way to tell dcount to use the query that is the
record source of the report? or do I have to repeat this query name in the
dcount function everytime it is used?
Text box Field example
=DCount("[II6]","qryMPV_DateRange_SelectNurses_FromForm","[II6]>0 and
[II6]<3 ")
Thanks for any ideas, CB