R
Ray
Hello,
I am working on an Access table with almost 200 variables say var1,
var2, var3....var200. Each var can have many errors. Each variable has
five possible error codes(say E1,E2, E3,E4,E5) . I am trying to do a
trending analysis where I would like to sort out the highest number of
errors.Here is a sample table
var1, var1err#, var1Errcode, var2, var2err#, var2Errcode.,,,,,,
AccName, 17, E1,situs state,10, E4,
Can somebody advice me on how I can create a table where I can calcuate
the total E1s, Total E2s......and sort them in the descending order? I
tried cross tab query but it will transpose the data only for a maximum
of three variables at a time. Can somebody please help?
Thanks.
Ray
I am working on an Access table with almost 200 variables say var1,
var2, var3....var200. Each var can have many errors. Each variable has
five possible error codes(say E1,E2, E3,E4,E5) . I am trying to do a
trending analysis where I would like to sort out the highest number of
errors.Here is a sample table
var1, var1err#, var1Errcode, var2, var2err#, var2Errcode.,,,,,,
AccName, 17, E1,situs state,10, E4,
Can somebody advice me on how I can create a table where I can calcuate
the total E1s, Total E2s......and sort them in the descending order? I
tried cross tab query but it will transpose the data only for a maximum
of three variables at a time. Can somebody please help?
Thanks.
Ray