How Can Access Identify & Count Duplicate Entries?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am working on a statistical probability problem.

How can access be used to count the statistical data?

I want Access to
1) list the individual answer only once
2) and count the # of occurances

How can this be done?

I have an excell spreadsheet that contains statistical data.

In the spreadsheet, there are 10,000 "yes/no" answers and
10,000 "A/B/C" answers. There are also 10,000 answers to
more complicated series questions "Choose either A/B/C
and then either D/E/F and then either G/H/I....ect"

The series questions also have individual answers (For
example, the series question, "Choose either A/B/C and
then either D/E/F and then either G/H/I", may produce
answers like "ADG" or "B,D,A"
 
From MS Access Help:

1. In the Database window, click Queries under Objects, and then click New on
the Database window toolbar.

2. In the New Query dialog box, click Find Duplicates Query Wizard, and then
click OK.

3. Follow the directions in the wizard dialog boxes. If you don't choose to
show fields in addition to those with duplicate values, the query results will
sum the instances of each duplicate value. In the last dialog box, you can
choose to run the query or see the query's structure in Design view.

If the resulting query isn't exactly what you want, you can rerun the wizard or
change the query in Design view.
 
Back
Top