hello everyone, I need to display the current number of active members..

i have a field "Estado" where it displays if the members is active or not...

If ( Fin de Membresia ≥ Get ( CurrentDate ) ; TextColor("OK";RGB(0;128;0)) ; TextColor("NO";RGB(255;0;0)) )

i dont know if the "Socios Activos" (Active Members) can be calculated by looking up the word OK.. and then display the total number that the word OK appears on member profiles in the Estado field?

all help is greatly appreciated!

Edited November 29, 200718 yr by Guest
tried to explain myself a little better

I prefer to create what I call a flag field for these kind of record qualifications. So, I'd change your field to:

flag_StatusActive = if ( MemExpireDT >= get (currentdate); 1)

this must be an unstored calc, bcs you need get (currentdate) to update.

Now, create a summary field in members,

TTLActive = Total of flag_ActiveStatus

Unfortunately, this will be slow, because it is an unstored calc.

You also can create a selfjoin relationship from members to members (cartesian) and then create an unstored calc = sum ( selfjoin::flag_ActiveStatus).

ok, i will try to do it..

lets see ho¡w it goes

thanks!

cant get it to work, nothing shows up on the fields...

what could be the problem?

I'll need some more detail to help. When you say, nothing shows up on the fields, which fields? What did you create? Any of the fields that I recommended? Can you post a copy?