Reply to thread

Message: [QUOTE="[MVP] S. Clark, post: 2154393"] I would do this in multiple steps. 1st, to another table, add all of the contact names for those that HAVE a type Grant. 2nd, For the remainder of the schools (which obviously don't have a type Grant) add the primary contact name. -- HTH, Steve Clark, Access MVP FMS, Inc. Professional Solutions Group [URL]http://www.FMSInc.com[/URL] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Is your Access database too slow? Are you ready to upgrade to SQL Server? Contact us for optimization and/or upsizing! [URL]http://www.FMSInc.com/consulting[/URL] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [/QUOTE]