Trend Analysis

[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

 

[PC Datasheet]

You need two tables that look like:
TblVariable
VariableID
VariableName

TblErrorCode
ErrorCodeID
VariableID
ErrorCode

You can then use a totals query on TblVariable joined to TblErrorCode
grouping on VariableName and ErrorCode doing a Count on ErrorCode. ErrorCode
will need to be included in the query twice. In case you are not familiar
with totals queries, you create a totals query by clicking on the Sigma
(looks like capital E) button on the toolbar at the top of the screen.

 

[StopThisAdvertising]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To the OP:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R