Access World Forums

Access World Forums (
-   Reports (
-   -   Monthly Report Memberships (

Tiffany Wong 08-22-2019 10:19 AM

Monthly Report Memberships

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
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
City State Zip
spouce first name
spouce last name

Group Drop Down To choose company group name

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

Group - Family
Group - Single

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