Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   Monthly Report Memberships (https://www.access-programmers.co.uk/forums/showthread.php?t=306490)

Tiffany Wong 08-22-2019 10:19 AM

Monthly Report Memberships
 
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 08-22-2019 10:23 AM

Re: Monthly Report Memberships
 
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 08-22-2019 10:28 AM

Re: Monthly Report Memberships
 
do you need a single report that will print as many times as you have members?

Tiffany Wong 08-22-2019 10:41 AM

Re: Monthly Report Memberships
 
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 08-22-2019 10:50 AM

Re: Monthly Report Memberships
 
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;


All times are GMT -8. The time now is 07:49 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World