• Replies 3 replies
  • Subscribers 216 subscribers
  • Views 34 views
  • Users 0 members are here
Related

Mmebership Levels

Former Member
Former Member $organization

Hello

I wonder if anyone can help, I'm writing in from the Donmar Warehouse in London.

I want to find out exactly how many members we have as of right now across all our membership levels (we have 7).

How do I go about getting this information? Each time we try various reports, we get different results, so not sure if we need to just use a list or if there is a specific report we can use?

Any help, ideas would be appreciated.

Thanks

Harminder

Parents
  • $organization

    If you just want a count list manager should do it. Within list manager you could simply use the "membership level" list element and use the "membership current" too if you make sure they are all active memberships. Otherwise you could just have the IT execute the below bit of code after editing the appropriate memb_levels for you org.

     

    --returns count


    select COUNT(distinct customer_no)
    from TX_CUST_MEMBERSHIP
    where memb_level in ('I60','I50','I40') --edit here
    and cur_record = 'Y'


    --Or... returns customer and memb_level and description

    select  a.customer_no, a.memb_level,b.description
    from TX_CUST_MEMBERSHIP a
    join T_MEMB_LEVEL b on a.memb_level = b.memb_level
    where a.memb_level in ('I60','I50','I40') --edit here
    and a.cur_record = 'Y'


    Travis

  • Former Member
    Former Member $organization in reply to Travis Armbuster

    Hi Travis

    That's brilliant the first code was really helpful and helped us get to some exact figures which we have been looking for.

    Thanks again

    Harminder

     

     

     

     

Reply Children
No Data