I would like to count different kinds of entries in a table:
If there are Fields X and Y:
X Y
1 A
2 A
3 B
4 B
5 B
The Sum must be "2" (Two different Values in Y)
X Y
1 A
2 A
3 B
4 C
5 A
Them Sum must be "3" (Three different Values in Y)
Understand? Any ideas?????? Thanks a lot!
Answers
You need to create a temptable in which you keep each value.
Then you have to scan the table and add a counter to the record in the temptable. I give an example for the no. of items in all item ledger entries:
recItemLedgerEntry is a record on table "Item Ledger Entry"
tmpItem is a TEMPORARY record on table "Item"
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!