At 11:18 AM -0900 11/3/00, Copper River Watershed Project wrote:
>I can generage a Giving Level Report, but the levels don't come up
>in numerical order. For example, here is the order for the most
>recent report I ran:
>
>$0
>$1 - 24.99
>$100 - 249
>$1000 +
>$25 - 49.99
>$250 - 499.99
>$50 - 99.99
>$500 - 999.99
>
>Any suggestions for how to get them in a more logical sequence?
The Member Status field is a text field, so it's sorted not in
numerical order but in ASCII text order, character by character.
First character (all $), second character (0, then 1, then 2), third
character, etc. You can define the names of the categories using the
setup wizard, so you should changed the names to something that would
sort in the order you want. For example, 1.Prospect, 2.Donor
3.SomethingElse ... would work for the first nine categories.
>Another question (they say there is no such thing as a dumb
>question, I hope I'm not testing that theory): how do other groups
>differentiate between contributions and dues? What would be the
>rationale for listing one of a member's payments as dues and another
>as contributions? It seems that you would want to give a member
>credit for all the payments he or she makes, and that if he or she
>pays $50 as "dues" but then later in the year makes other payments
>of $100 and other of, say, another $100, shouldn't they receive
>acknowledgement for having contributed a total of $250?
>
I am not organization staff, so take this for what it's worth. Seems
to me a member gets your newsletter, some status related to
"belonging" to the cause. A donor has responded to a special appeal
such as buying a new computer for the office, funding a legislative
update, etc. Basically they get status depending on the appeal to
which they responded.
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
