I put the following in my report footer but the field mediaEndDate is not recognized or found by the database even though this same field is working in another similar report. I just copied it over to this new report but its not working even though the fields exist and remain the same. In print preview access tells me run time err 2465 mediaEndDate field cant be found as its referred to in my expression.
Me.Text106 = DLookup(“blendpercentage”, “blendpercentages”, _
“month='” & Choose(Month(Me.MediaEndDate), “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”) & “‘ And type = ‘BE’ “)
