Hi,<BR><BR>I got this message,<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] The specified field &#039Day3&#039 could refer to more than one table listed in the FROM clause of your SQL statement. <BR><BR>The thing is that I know I have the same field in more than one table, I want to list everything in each table pertaining to this field. Anyone know how to get around this error message?<BR><BR>Thanks inadvance.<BR><BR>