J
Jerome Engel via AccessMonster.com
hello, i have folowing problem:
I want to create a report which is based on a query.
The query works without any problem.
but when I want to print out the result in a report I get following Errormessage:
The specified field 'name of the table.name of the field' could refer to more then one table listed in the FROM clause of your SQL statement
in the help I found that the errornumber is 3079.
I understand the meaning of the errormessage, but why does the querry work an the report doesn't so!
Jerome
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=edaf0b1bc2f941c08c607b4274f91aab
*****************************************
I want to create a report which is based on a query.
The query works without any problem.
but when I want to print out the result in a report I get following Errormessage:
The specified field 'name of the table.name of the field' could refer to more then one table listed in the FROM clause of your SQL statement
in the help I found that the errornumber is 3079.
I understand the meaning of the errormessage, but why does the querry work an the report doesn't so!
Jerome
*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=edaf0b1bc2f941c08c607b4274f91aab
*****************************************