Re: HELP: need query to convert separate records into the one

Clinton M James wrote:
>I have set up an access database that I communicate with through Excel
and 
>VBA.
>
>The purpose is to do auditing of staff.
>
>Because there are several audits, each audi has differing criteria to
mark 
>on, therefore the vba program I have made is dynamic in that the user can

>construct as many marking criteria as needed.
>
>Thing is, the data gets stored as individual records for each criteria 
>marked with a column that carries the linking number to refer it back to
the 
>criteria to which it applies then this criteria is linked to the audit 
>itself.
>
>Because the ****gram is dynamic in that it allows the user to have as many

>criterias as they link is there a code that allows me to grab the records

>that represent the full criteria for the audit and then dump them into
one 
>row or will i have to just get all the data and construct code in vba to
do 
>it for me?


Not sure I understand, but cimbining values from multiple
records does require some code.  There's a good Function to
do that at:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records'

--
Marsh