I did the same thing as smv929 and it worked like a charm. For some reason the Report Wizard doesn't like temp (#) tables. Just let your sp create a...

You also cannot use any Access specific function such as DSum. I ran into this problem. What I did to get around it is convert the Access query to a...

I am in the same boat. Any feedback would be appreciated.

I am issuing a SELECT statement against the temp table.

Airolq, I'm glad the community could help solve your problem. I also *think* that you have to have certain/higher rights/permissions to use the TRUNCATE command. DRussel, I never even thought...

DRussell, using DELETE FROM will not reset your uniqueidentifier count to 1, but using TRUNCATE TABLE will. I use it all the time and it IS a logged operation in...

Also, try double clicking on the message line in QA where it tells you that you have an error. i.e. -- "line missing )". If you double click anywhere on...