tolits009
New Member
A user asked me the following:
count transactions where a table contains example:
document# idno code
0001 001 CS001
0001 002 CS002
0001 003 CS001
003 CS002
0001 004 CS001
004 CS002
0001 005 CS001
005 CS002
0001 006 CS001
006 CS002
my problem is i have to count document 0001 ONLY ONCE
where the code contains [CS001 AND CS002]
and so on....
how do I do it?
count transactions where a table contains example:
document# idno code
0001 001 CS001
0001 002 CS002
0001 003 CS001
003 CS002
0001 004 CS001
004 CS002
0001 005 CS001
005 CS002
0001 006 CS001
006 CS002
my problem is i have to count document 0001 ONLY ONCE
where the code contains [CS001 AND CS002]
and so on....
how do I do it?