SELECT * FROM#temp1 (yes why didnt i think of that? LOL )

Ah that returns what i am expecting - so error is somewhere in my vb code

thanks

Mike

Hi again

one problem is that when i import the new table into a dataset.table it has 8 columns which are the same as the "Account" table

where as my original...

Thankyou thats great!:D

I am using the data in the same procedure - will not be kept long

Mike

Thanks

I tried this in management studio and got the error 'Incorrect syntax near the keyword 'Into'.

select account.nameof as account,

sum (entry.credit-entry.debit) as total from entry,account

where entry.account=account.nameof

and entry.Taxyear...