Getting only latest date info into a report

[fshrago]

I have created the following query which correctly returns only the fields with the latest date:



SELECT CheckDate.CheckDateID, CheckDate.CheckDate, CheckDate.CheckDone, CheckDate.Notes, CheckDate.AptID
FROM CheckDate INNER JOIN qryLatestCheckDate ON CheckDate.AptID = qryLatestCheckDate.AptID
WHERE (((CheckDate.CheckDate)=[qryLatestCheckDate]![MaxOfCheckDate]));

However, when I use this query in a Report I get an error:

The specified field 'checkdate.checkdate' could refer to more that one field in the FROM clause of your SQL statement.

The report was built with the report wizard, so shouldn't this correctly name the fields?

There is a field in the report called whose source is specified as: checkdate.checkdate if I remove this field from the report, then the report correctly only gives me the information for the latest date, but only without the actual date field in the report?!

Thanks

[June7]

You mean there is a textbox on the report with ControlSource of CheckDate.CheckDate? Since I see only one field in the query named CheckDate, shouldn't need the tablename prefix. Either drag the CheckDate field from the field list or create textbox and select the field from the ControlSource drop down.