Monthly Report Memberships (1 Viewer)

Tiffany Wong

New member
Local time
Yesterday, 18:28
Joined
Aug 22, 2019
Messages
3
Hello,


I am looking to create a report monthly that will generate how many letters I will need to print out....



Making sure even if the members have not renewed that they are included.


This report will help me to make sure I have exact numbers that have been mailed out.



We have two different memberships
TCMTA
LSA (Family-Single, Family-Group, Group-Single, Group-Family)


would like the report to distinguish between the two....
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:28
Joined
Oct 29, 2018
Messages
21,358
Hi. Several approaches are possible, but it's hard to offer any suggestion without knowing your setup. Are you able to post your table structure?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 09:28
Joined
May 7, 2009
Messages
19,169
do you need a single report that will print as many times as you have members?
 

Tiffany Wong

New member
Local time
Yesterday, 18:28
Joined
Aug 22, 2019
Messages
3
The table is standard with member information to be gathered
Last Name
First Name
Address
City State Zip
County
email
telephone
spouce first name
spouce last name
DOB


Group Drop Down To choose company group name


membertype drop down (# Associated on table to the below names)

Family
Single
Group - Family
Group - Single
TCMTA
REACH
PHI



date joined
date expires
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 09:28
Joined
May 7, 2009
Messages
19,169
still no understand.
do you need the total count of each Groups?
if so, you can create a crosstab query:

transform Count(memberType)
select "No of Members" As Expr1
from yourTableName
group by "No of Members"
pivot memberType;

or use Aggregate query:

select memberType, Count("1") As [No Of Members]
from yourTable
group by memberType;
 
Last edited:

Users who are viewing this thread

Top Bottom