Hi All,

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 porgram 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?

Your assistance is appreciated and thank you in advance.

Regards,
Clint