Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-22-2019, 10:19 AM   #1
Tiffany Wong
Newly Registered User
 
Join Date: Aug 2019
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Tiffany Wong is on a distinguished road
Question 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....

Tiffany Wong is offline   Reply With Quote
Old 08-22-2019, 10:23 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,146
Thanks: 46
Thanked 971 Times in 952 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
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?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 08-22-2019, 10:28 AM   #3
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,033
Thanks: 65
Thanked 2,560 Times in 2,457 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Monthly Report Memberships

do you need a single report that will print as many times as you have members?

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 08-22-2019, 10:41 AM   #4
Tiffany Wong
Newly Registered User
 
Join Date: Aug 2019
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Tiffany Wong is on a distinguished road
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
Tiffany Wong is offline   Reply With Quote
Old 08-22-2019, 10:50 AM   #5
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,033
Thanks: 65
Thanked 2,560 Times in 2,457 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
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;

__________________
"Never stop learning, because life never stops teaching"

Last edited by arnelgp; 08-22-2019 at 10:56 AM.
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Monthly Report miky348 Reports 0 05-23-2013 12:30 AM
Calculating gaps between memberships JobieJo General 1 10-05-2012 09:20 AM
Need HELP.. New To Access how to condence a report and making it a monthly report F.E.A.R 2 Reports 3 12-02-2009 03:55 PM
Memberships benc General 3 04-21-2004 09:28 AM
Monthly Report pankajeshwara Queries 3 06-19-2002 07:02 AM




All times are GMT -8. The time now is 09:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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