Help needed with combined Dlookup/DatePart Syntax

[Tony Ciconte]

I am using Acc97 and trying to get the following instruction to work
in the OnOpen event of a report:

DLookup("[GiftAmt]", "tblTempRevenueByFY", DatePart("m", [GiftDate]) =
1)

The table tblTempRevenueByFY exists, with data, as do the fields
"GiftAmt" and "GiftDate". However, when I try to preview the report, I
get 2465 error that says it cannot find the field "GiftDate". I have
tried every combination of quotes, double-quotes, parentheses, etc.
that I can think of and get mostly compile errors. I have also
searched the Google groups for insight without avail.

Any and all help is greatly appreciated

TC

[Douglas J. Steele]

The 3rd argument (the WHERE part) needs to be in quotes as well. Note that I
put single quotes around 'm' to avoid problems with quotes within quotes.

DLookup("[GiftAmt]", "tblTempRevenueByFY", "DatePart('m', [GiftDate]) =1")
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Tony Ciconte" <to******@comcast.net> wrote in message
news:0j********************************@4ax.com...

I am using Acc97 and trying to get the following instruction to work
in the OnOpen event of a report:

DLookup("[GiftAmt]", "tblTempRevenueByFY", DatePart("m", [GiftDate]) =
1)

The table tblTempRevenueByFY exists, with data, as do the fields
"GiftAmt" and "GiftDate". However, when I try to preview the report, I
get 2465 error that says it cannot find the field "GiftDate". I have
tried every combination of quotes, double-quotes, parentheses, etc.
that I can think of and get mostly compile errors. I have also
searched the Google groups for insight without avail.

Any and all help is greatly appreciated

TC