Dlookup problem

[CalifDan]

I am trying to place a particular field in an unbound text box in the summary section of a report.

The report is bound to a query which properly returns the values to run the report. The database and report tracks the gifting of properties.

The relevant fields in the Gift_Table are:

Gift_PropertyValue
Giftee
Gift_Year
Gift_PropertyAddress



I want to put the last years Gift_PropertyValue in the unbound control for purposes of comparison and to carry out some calculations in other fields. I am using the following Dlookup with some variations.

DLookUp("[Gift_PropertyValue]","[Gift_Table]","[Gift_Table]![Gift_Property]='property address' AND [Gift_table].[Gift_Year]='2009' and [Gift_Table]![Giftee] = 'giftee name'")

With this one I get a null response. With some variations I either get error or the first record matching Gift_Property and Giftee but ignoring the year.

I am missing something. Any help?

Thanks. CalifDan

[RuralGuy]

Don't scope the fields!
DLookUp("[Gift_PropertyValue]","[Gift_Table]","[Gift_Property]='property address' AND [Gift_Year]='2009' and [Giftee] = 'giftee name'")
http://www.mvps.org/access/general/gen0018.htm

[CalifDan]

This is one of the variations I have tried. I put it in exactly as indicated (I beleive) and the record definitely exists. I checked each criteria specified against the actual field in the record. I am getting a null response....no record.

What else could it be?

CalifDan

[RuralGuy]

Is Gift_Year a number or a string? Is it a DateTime field?

[SoftwareMatters]

This maybe just a typo but in your list you have Gift_PropertyAddress and in your DLookup you have [Gift_Property]