How do I can count different codes in different fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with various different codes across 18 fields. How do I
obtain a total count for each code. Is there an easy way of doing it? Am
fairly new to Access. Please help.
 
The same codes are reused over 18 different fields? Might be a design error
here, hence your problem.

Does the same code can appear on two fields or more for the same record and
if yes, do you want to count this situation as 1 time or 2 times?

The easiest way for you might be to create some piece of code in VBA to open
a recordset on the table and then scan the table while counting the number
of time each code is used.

S. L.
 
Thank you for responding.

Yes the same codes are used in various fields, and I need to count each code
as it appears.

Unfortunately, being new to Access, I'm still learning. Can I found out how
to use a "recordset" in the help section? I have Access 2000.
 
I would create a union query to normalize the 18 fields into a single column
and possibly 18 records per. Someone could provide more specific help if you
provided some field names. It would also help to know if all 18 will always
contain information.

Sylvain may have been asking if two or more of the same code might be used
in the same record but different fields. If so, how would this be counted?
 
Back
Top