"change the parameter to a table variable" - Brilliant!!! 😀

Thanks!

http://msdn.microsoft.com/en-us/library/bb264566(SQL.90).aspx

USE THIS!!!

When I use this query in SQL server 2008 it works just fine...

But, when I use it it access It bombs out and says, "Join expression is not supported". And...

Awesome! That works..

How can I add a where clause? Once I add it I dont get the results I need.

WHERE Sales.FISCAL_YR = 2008

This does not work. I get the same results as

SELECT Sales.SERVICE, Sales.FISCAL_YR, Sales.R_UNITS, Sales.R_SALES, Sales.A_UNITS, Sales.A_SALES, Sales.I_UNITS, Sales.I_SALES

FROM ...

Yes that would be great. I'm new to SQL and trying to learn as much as possible.

Thank you all for your help.. You guys rock!!!!

The problem was that I was including the table name on my second select. I was thinking more about it trying to...

WOW! you guys are good... I was'nt expecting such a quick response. Awesome... Thanks.

They both work like a charm. You have seriously saved my but with this. It was the...