How can I Calculate that???

[George TOUBALIS]

How can I Calculate that??? ( the result is in field "Active & Inactive" )

3 Field

Group Active or Inactive Active & Inactive

10 Active 001 Active 001 Inactive 001

10 Active 001 Active 001 Inactive 001

10 Active 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

11 Active 002 Active 002 Inactive 002

11 Active 002 Active 002 Inactive 002

11 Active 002 Active 002 Inactive 002

11 Inactive 002 Active 002 Inactive 002

11 InActive 002 Active 002 Inactive 002

11 InActive 002 Active 002 Inactive 002

AnyBody? Please!

George

[-Queue-]

I'm not sure what you're asking. Could you be more descriptive?

[George TOUBALIS]

The group "10" has 1 of 2 values "Active 001" or "Inactive 001"

The group "11" 1 has 1 of 2 values "Active 002" or "Inactive 002"

I want a Calculation to collect the active values and the Inactive values of one group in one field...

Group------Active or Inactive------- Active & Inactive

10------Active 001--------------- Active 001 Inactive 001

10------Active 001--------------- Active 001 Inactive 001

10------Active 001--------------- Active 001 Inactive 001

10-----Inactive 001--------------- Active 001 Inactive 001

10----- Inactive 001--------------- Active 001 Inactive 001

10----- Inactive 001--------------- Active 001 Inactive 001

11----- Active 002--------------- Active 002 Inactive 002

11 ----- Active 002--------------- Active 002 Inactive 002

11 ----- Active 002 ---------------Active 002 Inactive 002

11---- Inactive 002 ---------------Active 002 Inactive 002

11---- InActive 002--------------- Active 002 Inactive 002

11---- InActive 002 ---------------Active 002 Inactive 002

[Oldfogey]

You've lost me.

Is your example showing 12 posible records? If so, the apparent end result is the same in all cases so why do you need a calculatin?