Dlookup field from query

[eebabe]

Hi:

Is it possible to dlookup fields from queries? I tried this:

=DLookUp("[HRI Refused Svcs]", "q_HRI_Ref/Refsd_Cnt",
"[Program] = '10'")

It didn't work maybe because the syntax is wrong. Perhaps there is a better way to reference fields from queries. If it's not possible, maybe I can create a report from the query and then reference that field from the report. Is this even possible?

Thanks.

 

[dhookom]

eebabe,
Is [Program] text or numeric? Your expression suggests it is text.

Did you try wrap you query name with []s since there is an / in the middle of the name?



Duane
Hook'D on Access
MS Access MVP