HELP: need query to convert separate records into the one

[Clinton M James]

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

[Marshall Barton]

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

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.rogersacces slibrary.com/Otherdownload.a sp?SampleName=' Generic%20Funct ion%20To%20Conc atenate%20Child %20Records'

--
Marsh

[Bob Quintal]

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

"Clinton M James" <notrealaddress @yahoo.comwrote in
news:481dcb57$0 $2834$5a62ac22@ per-qv1-newsreader-01.iinet.net.au :

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
>

A crosstab query sounds like what you need. The crosstab transposes
rows into columns in a row, The Excel Pivot Table can do similar
things, and may even be better for your purposes.


--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **