I need to add-up the number of times the same value (element) is used in a
single record (row.)

On Tue, 27 Mar 2007 18:09:51 -0700, N.Janopoporolus
<(E-Mail Removed)> wrote:

>I need to add-up the number of times the same value (element) is used in a
>single record (row.)

Then you need to redesign your non-normalized table structure.

For a more detailed answer please post a more detailed description of your
table, and what you mean by an "element".

John W. Vinson [MVP]