Query Results in unbound form field

I am trying to use dlookup to put the results of a query (AAA) into a form's
unbound field

AAA
SELECT Sum(Payment_tbl.pmtAmt) AS SumOfpmtAmt, Year([pmtDate]) AS pmtYear,
Month([pmtDate]) AS pmtMo
FROM Payment_tbl
GROUP BY Year([pmtDate]), Month([pmtDate])
HAVING (((Year([pmtDate]))=Year(Now())));

Form Field
=DLookUp("pmtAmt","AAA",[pmtMo]=4)

getting an #Name error

On Tue, 1 Jul 2008 22:08:00 -0700, Brian wrote:

> I am trying to use dlookup to put the results of a query (AAA) into a form's
> unbound field
>
> AAA
> SELECT Sum(Payment_tbl.pmtAmt) AS SumOfpmtAmt, Year([pmtDate]) AS pmtYear,
> Month([pmtDate]) AS pmtMo
> FROM Payment_tbl
> GROUP BY Year([pmtDate]), Month([pmtDate])
> HAVING (((Year([pmtDate]))=Year(Now())));
>
> Form Field
> =DLookUp("pmtAmt","AAA",[pmtMo]=4)
>
> getting an #Name error

You don't have a field named "pmtAmt" in the query.
You do have a field named "SumOfpmtAmt".
Is that the value you wish to display in the control?
Does the query return just one record? If yes then:

=DLookUp("[SumOfpmtAmt]","AAA")

If there are more than one record being returned by the query then you
have to use criteria to get the correct value. The criteria argument
must be a string.
=DLookUp("[SumOfpmtAmt]","AAA","[pmtMo] = 4")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail