Hi all, just following up these replies.

Yup, from what I understand SQL Server uses T SQL which is different in syntax to the SQL that Access uses. I just use...

Cheers Ninja.

Sounds like I do have a different setup, probably because I'm building this from an Access perspective and SQL Server came into the mix after.

All my tables are upsized...

I think I may have set it up incorrectly !

I have the View from SQL Server linked into the Access mdb as a table via ODBC. I could of course...