Report Format in rows not columns 1

[smatthews]

I am trying to create a report that has different rows instead of different columns for each type of member for our assocation but I can't seem to find a good way to format. Below is an example:

Paid Members 724
Potential Members 51
Potential Associate Members 22

I tried a crosstab query using an "if" then "else" formula but I was getting both the people who fit the criteria for the qroup as well as people who did not. They were separate however.

Does anyone have a suggestion on the best way to format the report? Thanks in Advance, Susan

 

[synapsevampire]

A bit vague for this ole noggin.

This looks like 3 counts??? Running Totals allow for formulas that decide what would get included (Evaluate->Use a Formula), if you only have 3 elements, use 3 Running Totals and insert the criteria for each in there.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com