Actually all I am doing is updating the pass thru query that allows me to send 2 variables needed for a stored procedure on SQL Server.  the pass-thru does NOT...

ok, let's run a scenario here for example.

say I have a table of software a dept uses.  I have 10 items and these were all used in 2004.  Now in...

users are viewing from Web (PHP) and retrieving the data from SQL Server.  I need to let them retrieve their data and edit/update it for accuracy and then save it...

Basically the article says not to do what I want to do.  But I need a way to create tables with unique names based on the user requesting the data. ...

Vladan,

You are AWESOME!! It worked.

I thought VBA could be syntax sensitive, now I SQL Server wins that...

Thx AJ,

You are correct I was missing the 2nd group by field... however I still get the same error message.

Question... I have SQL Server Developer loaded onto my laptop, is...

I tried what you suggested but for some reason I am still getting an error message of :

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near...