Counting

  • Thread starter Thread starter Hal Pratt
  • Start date Start date
H

Hal Pratt

I need to track the number of time a record is selected for promotion. I add
a number field for every promotion and update with 1 for selected records.
See example:
Field1 3 4 5 6
66204CULP6806 A 1

1
66204DACH7635 W


1
66204DAVI7145 R
1


75442BRIT410 N 1

1


Now I want to add a new field which totals each row or record. (i.e., row1
=2, row 2=1, etc.)
How should the expression be composed?
 
Hal,

Are you able to change your table design? I do not really understand
the data you have presented, but I can say for sure that the structure
of it is not really applicable to a database.
 
Back
Top