Patrick O'Dea
asked on
Using SQL within VBA (based on combos)
Hi,
See attached.
This is a simplified version of my requirement.
I have a table with thousands of records and wish to "count" the records that match the criteria chosen by the combos. E.g. choose "Gender=M" and "Personality=NICE". How many people match these criteria?
This is best explained by looking at the attached.
What I Need: When the user clicks "Count The Chosen" the system should display a msgbox that show how many records met the criteria.
GenerateLetters.accdb
See attached.
This is a simplified version of my requirement.
I have a table with thousands of records and wish to "count" the records that match the criteria chosen by the combos. E.g. choose "Gender=M" and "Personality=NICE". How many people match these criteria?
This is best explained by looking at the attached.
What I Need: When the user clicks "Count The Chosen" the system should display a msgbox that show how many records met the criteria.
GenerateLetters.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER