If you know SQL, it would probably be easiest to create a command.  It would look something like this:

Select <fields for your report>
from <tables for your report, including joins>
where <selection criteria for your report>
  and dbo.CPlan_tblSurveyAnswer.UpdatedDate =
    (Select max(GetDate.UpdatedDate)
     from dbo.CPlan_tblSurveyAnswer as GetDate
     where <links to the data above>)

Here's an example from something I've done:

Select l.lender_number, l.loan_number,
  l.inactive_ind, lh.posted_to_history_date
from loan as l
  inner join loan_history as lh on lh.history_key = l.history_key
where l.escrow_ind = 'YES'
  and lh.posted_to_history_date =
  (Select max(GetDate.posted_to_history_date)
   from loan_history as GetDate
   where GetDate.lender_number = l.lender_number
      and GetDate.loan_number = l.loan_number)

 

You then use the command in your report instead of the tables.

 

-Dell