Group on value

[Frank336]

Hi, im using VB6, rdc(cr8.5), access 2000

How can i get that structure (Im grouping on Code) ?

Code = A
ID 1
ID 2

Code = B
ID 3
ID 4

Code = OTHERS (all the other codes (C, D, E, ETC.) )
ID 5
ID 6
ID 7


(The list of code is not static)


Thanks,
Frank

 

[dgillz]

Create a formula field:

If {Code}="A" then "A" else if {code}="B" then "B" else "OTHERS"

Group on this formula field. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com