With memo fields, I think you must split the select into more than one, three in this case.
1. Select SELECT web_FundType.DiscName, FROM iAccts;
JOIN web_FundType ON iAccts.FundTypeId = web_FundType.FundTypeId GROUP BY web_FundType.DiscName ..
2. Another select to add the disclose2 field
3. Insert from the cursor created in 2

>I was trying to update the post, but you were too quick! Verbage is a memo field. I had a similar problem a week or so ago, but I can't find the thread now.
>
>>You must include all the fields in the Group by clause

>>INSERT INTO crsDisclaimer (DiscName, Verbage) ;
>>	SELECT ;
>>		web_FundType.DiscName, ;
>>		web_FundType.Disclos2 AS Verbage ;
>>		FROM iAccts ;
>>		JOIN web_FundType ON iAccts.FundTypeId = web_FundType.FundTypeId ;
>>		GROUP BY web_FundType.DiscName,web_FundType.Disclos2

>>
>>>Just can't seem to get this to work. I tried to break it up into two statements, but still not getting the results I need. Any help is appreciated.
>>>
>>>

>>>INSERT INTO crsDisclaimer (DiscName, Verbage) ;
>>>	SELECT ;
>>>		web_FundType.DiscName, ;
>>>		web_FundType.Disclos2 AS Verbage ;
>>>		FROM iAccts ;
>>>		JOIN web_FundType ON iAccts.FundTypeId = web_FundType.FundTypeId ;
>>>		GROUP BY web_FundType.DiscName
>>>