Probably going to need to use a cursor or an in memory table. Definitely possible to do what you want but I don't think in straight SQL though.<BR><BR>--The Dan ...

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to ...