Error message when trying to generate report

  • Thread starter Keith Yong via AccessMonster.com
  • 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!
 
D

Duane Hookom

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message 1
query runs - report has error 4
Can't create a report from my query in Access 1
Sub report message 18
Error message when running report 12
Error Message when running report 5
how to generate a report from Form output 5
Report will not generate 3

Top