Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    field in footer is not recognized (97)

    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' ")

  2. #2
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: field in footer is not recognized (97)

    never mind I fixed it, I was using the wrong name DOH!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •