thanks for the queries. think ill leave this task, it seems a little too hard as i was trying to combine both scripts into one so i could use it...

yeh that works great!!

one slight problem is that it displays entries for all the posts,

At the moment it shows.

ThreadID PostID LastPostDate

4 1...

Im am still getting this error...

http://img451.imageshack.us/img451/3696/error0ka.jpg

any more help is greatly appreciated as this is so frustrating.

Ben

P.S the database is here http://www.sendspace.com/file/6v9yov if this...

i get an error saying syntax error in FROM clause (highlighting the first join).

if i change it to inner join i get this error message:

Syntax error (missing operator) in query...

I get a syntax error in FROM clause (highlighting the last join)

for this code

select t.ThreadID,

t.ThreadName,

...

will do. thanks

im afraid i cant get either of these to work, access keeps throwing up errors.

I have uploaded the DB to here http://www.sendspace.com/file/6v9yov,

its only 20k so if...

the query should for all threads.

thanks,

ben

yeh i managed to figure it out in the end cheers

ok, I have another problem with the hosting. i have no permissions to drop the table. i can truncate the table but when i run the script again, substituting truncate...

hi,

firstly thanks for all the replies!!

Marshall Smith's suggestion threw up some errors i couldnt understand.

Farrell Keough's suggestion kept mentioning group by error messages which i couldnt get...

ALTER TABLE myTAB ADD newIDcolumn INT NOT NULL IDENTITY(1,1) PRIMARY KEY

worked a treat thanks!

thanks for the help, im used Eddie Wuerch's suggestion and it works great!

ben

used RyanRandall's suggestion and it worked great!

thankyou

WOW, that works a treat!!

thanks a lot noeld