Member Avatar for JFunk
JFunk 0 Newbie Poster

Hi,

I've created a query that inner joins 4 tables. The tables have a common field CPname and CoverType. The query works and results are correct.

However, when I use this query as my record source for a report, I came up with this error:
"The specified field 'TblCover.CoverType' could refer to more than one table listed in the FROM Clause of your SQL statement".

I have changed fieldname to incorporate the table name in front:
TblCover.CoverType instead of just using CoverType as control source/fieldname.

Still error persist.

Can someone please help me?

Thanks,
JFunk

  • 1 Contributor
  • 0 Replies
  • 68 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.