Error message when trying to generate report

  • Thread starter Thread starter Keith Yong via AccessMonster.com
  • Start date Start date
K

Keith Yong via AccessMonster.com

Hi,

I received the following error when I tries to generate my reports. The
query runs fine but the report has the following error:

" The specified field 'tblPerformance.Date' could refer to more than one
table listed in the FROM clause of your SQL statement."

I'm using a parameter query like the one in
http://www.fontstuff.com/access/acctut08.htm and the sources of the fields
in this report come from 4 different queries.

Could someone advise on what is the problem and possible solutions? Thanks!
 
Could you share the sql view of your report's recordsource?

BTW: date is a poor name for a field since date is also a function. If
possible, you should change the name to ReviewDate or PurchaseDate or
ProjectDate or...
 
Back
Top