Additional columns displayed in access query output (1 Viewer)

Hi

Have a complex query joining multiple tables and queries. My issue is that I get additional columns when I run the query in access, while these columns are not even included in the query.

My Access release is 2010. Anybody has any idea why this is happening.


Thanks and Regards

Diogo Fernandes

First off, can you post the SQL from your final query?

Hi

Thanks for the reply Boblarson. Your question itself solved the problem

When u mentioned the SQL checked it and realised that there is an [,* ] appears on its own in the SQL after the last column name, I removed it manually and all is fine.

I dont know if its a bug but sometimes if u use the wizard, access puts the * on its own. When its a complicated query u tend to not look at the SQL syntax.

Thanks for the highlight

Regards

Diogo