I think this would fly in MS SQL server(which I usually use) but I'm getting and error from access when I try to run it: INSERT tbOptions (tbQuestionsFK, Value, supplementalValue1, supplementalValue2, supplementalValue3) SELECT 20 AS tbQuestionsFK, tbContentClassifications.id, tbContentClassifications.name, tbContentClassifications.description FROM tbContentClassifications where tbContentClassifications.tablePK >= 5 AND tbContentClassifications.tablePK <=23 It tells me "syntax error in INSERT INTO statement", even though it's a insert select not a insert into. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
