The query is fine but you need to identify where are you taking certain fields from. For example, "ThreadID" appears in THREADS and POSTS, so use something like

select

 t.ThreadID,

 t.ThreadName,

 t.ThreadDescription,

 u.UserName as...

If you want a (T-SQL) query and your table "data" has a PK, say ID, you can do this:

select (select count(b.ID) from data b where b.ID <= a.ID) as...

Try this one:

http://www.functionx.com/access/index.htm

Thanks for the replies, guys! I really apreciate it.

Probably Yelena is right that it's a Firewall issue bacause the sysadmin mentioned the same but we haven't looked into it yet....

So, it seems that my post does freak you out... Not to worry, I feel the same about the "situation".     By the way,...