" Invalid name

[Skip Bisconer]

While trying to create a query in a new database on tables linked from a converted 2003 to 2007 database. When including tables in my query, two of the three say " is not a valid name. Check for special characters...etc. I have renamed the tables, verified field names and there are not any special charcter. Can someone tell me where else to look for such problem. It will let me buid the query but not use it. I appreciate any help you can give me. I have built queries using the same tables in the converted database with no issues.

 

[Skip Bisconer]

When I run this particular query it runs, however, if I try to open it in design view I get the error halt I mentions. Here is the SQL statement.

SELECT tblOrderHeader.OEOO_ORDR, tblOrderHeader.OEOO_STAT, tblOrderHeader.OEOO_CUST, tblOrderLines.OEOO_PART, tblOrderLines.OEOO_QORD, tblOrderLines.OEOO_QSHP
FROM (tblOrderHeader INNER JOIN tblOrderLines ON tblOrderHeader.OEOO_ORDR = tblOrderLines.OEOO_ORDR) INNER JOIN tblOrderTotals ON tblOrderHeader.OEOO_ORDR = tblOrderTotals.OEOO_ORDR;

 

[kermitbuns]

When I run this particular query it runs, however, if I try to open it in design view I get the error halt I mentions. Here is the SQL statement.

SELECT tblOrderHeader.OEOO_ORDR, tblOrderHeader.OEOO_STAT, tblOrderHeader.OEOO_CUST, tblOrderLines.OEOO_PART, tblOrderLines.OEOO_QORD, tblOrderLines.OEOO_QSHP
FROM (tblOrderHeader INNER JOIN tblOrderLines ON tblOrderHeader.OEOO_ORDR = tblOrderLines.OEOO_ORDR) INNER JOIN tblOrderTotals ON tblOrderHeader.OEOO_ORDR = tblOrderTotals.OEOO_ORDR;

I have the same problem as Skip. The query worked fine, then when I tried to create a Query of the two Query results, i started getting the Invalid name error. The Query name is "Weekly Report" and now I can't execute the query, only view it in design mode.

Any Help??? Please?!

 

[Skip Bisconer]

Still getting this error when combining two linked tables into one query. I can only view in SQL not design view. When I try I get an Invalid name error and it will not let me proceed. I am able to make a query of each table separatly but I cannot combine either one. I tried making a new table with each query separatly and the do a query combining the two new tables and same issue pops up. Can anyone direct me somewhere to find this answer? This is my SQL statement. I see nothing in there that should cause a problem.

SELECT tblInPartMaster.INPM_PART, tblInPartMaster.Vcode, tblInPartMaster.INPM_DESC, tblInPartMaster.INPM_PCLS, tblInPartMaster.INPM_ACIN, tblInPartMaster.INPM_MVID, tblInPartMaster.INPM_MVUM, tblInPartMaster.INPM_MVOQ, tblInPartMaster.INPM_MBPR, tblInPartMaster.INPM_MBCS, tblInPartMaster.ListMargin, tblInWhseQuantities.INPM_BWID, tblInWhseQuantities.INPM_BQMX, tblInWhseQuantities.INPM_BQMN, tblInWhseQuantities.INPM_BQOO, tblInWhseQuantities.INPM_BQOH, tblInWhseQuantities.INPM_PCLS
FROM tblInPartMaster LEFT JOIN tblInWhseQuantities ON tblInPartMaster.INPM_PART = tblInWhseQuantities.INPM_PART;