> Yep, if its a complex formula, then a temp table would be the way to go. > Permissions shouldnt be an issue as long as you preface the temp table > with a "#" you still need permission to "create temporary tables" which is not always a default option. -Chris