"Clinton M James" <notrealaddress@[EMAIL PROTECTED]
> wrote in
news:481dcb57$0$2834$5a62ac22@[EMAIL PROTECTED]
> 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 ****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?
>
> 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
**
|
