Hi All,
I have a very difficult report, unfortunately a lot of the database is laid out like this so I really need some help!
I have a field in my reports
ProductID
it contains codes for products however, a customer many have many products
Name ProductID No. of Customers
Basic Gym Member 100 100
Max Gym Member 102 100
Light Gym Member 103 100
Premium Classes 104 10
Extra Classes 105 10
Light Classes 106 10
Total number in Gym : 300 of those 30 have classes
To have Premium classes, Extra Classes or Light Classes you must have either Basic Gym Member, Max Gym Member or Light Gym Member.
I need a report that will show a list of accounts which have Gym membership with the following criteria - it is to be broken into separate lists as per numbered breakdown below.
Detail and Selection Criteria:
Account Number
Full salutation and name details
Full address details
All contact numbers
Premium Classes
Extra Classes
Light Classes
Other Gym Members
In my Record Selection I have put ProductID in [100,101,102,103,104,105,106] I have written a formula that breaks up the productID in it's titles and grouped by it.
It comes out like this
Premium Classes 10
Extra Classes 10
Light Classes 10
Other Gym Members 300
Total: 330!!!!
Does anyone know how I could restrict this?
Many thanks,
NickyNin
I have a very difficult report, unfortunately a lot of the database is laid out like this so I really need some help!
I have a field in my reports
ProductID
it contains codes for products however, a customer many have many products
Name ProductID No. of Customers
Basic Gym Member 100 100
Max Gym Member 102 100
Light Gym Member 103 100
Premium Classes 104 10
Extra Classes 105 10
Light Classes 106 10
Total number in Gym : 300 of those 30 have classes
To have Premium classes, Extra Classes or Light Classes you must have either Basic Gym Member, Max Gym Member or Light Gym Member.
I need a report that will show a list of accounts which have Gym membership with the following criteria - it is to be broken into separate lists as per numbered breakdown below.
Detail and Selection Criteria:
Account Number
Full salutation and name details
Full address details
All contact numbers
Premium Classes
Extra Classes
Light Classes
Other Gym Members
In my Record Selection I have put ProductID in [100,101,102,103,104,105,106] I have written a formula that breaks up the productID in it's titles and grouped by it.
It comes out like this
Premium Classes 10
Extra Classes 10
Light Classes 10
Other Gym Members 300
Total: 330!!!!
Does anyone know how I could restrict this?
Many thanks,
NickyNin