Possible combination


I created a filter form whereby users are prompted to enter date intervals, select value from drop down list and click a button to see the result (filtered records)
I have 8 date fields and 6 combo boxes with multiple options to select a single value from.
Drop down #1 ‘Status’: 5 options
Drop down #2 ‘Close Reason’: 4 options
Drop down #3 ‘Department’: 10 options
Drop down #4 ‘Employee’ :16 options
Drop down #5 ‘Type’: 2 options
Drop down #6 ‘Agency’:4 options

I’m trying to determine the number of combination/permutations report can be generated from above.

OceanCityData Analyst Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
Not sure why that matters?

if a value is required in each combo = 5 * 4 * 10 * 16 * 2 * 4

if user doesn't have to select an item in each combo = 6 * 5 * 11 * 17 * 3 * 5

But neither of those includes the 8 date fields.

What are you really trying to do here, I seriously doubt it is just determine the total number of possible combinations/permutations of values in these 14 controls.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OceanCityData Analyst Author Commented:
Thank you,

It was just out of curiosity as the question came up approximate number of report that can be generated. The first part (if value is required) is clear.  How did you come up with the second part of the calculation?  And, if we include date fields, is it going to be * 8?

Dale FyeOwner, Developing Solutions LLCCommented:
For the 2nd value, the assumption that No value selected in the combo is essentially a value that equates to "any value", so I added 1 to each of the explicit values represented in each combo.  You might also have the possibility that the field associated with any of those combo boxes IS NULL, which might be another value.

Regarding the dates, since each of those date values could represent any number of dates (lets just assume each date field could represent just 30 days), then the number of date combinations (disregarding your combos) would be 30^8.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Dale FyeOwner, Developing Solutions LLCCommented:
to determine the number of legitimate combinations of the combo box values, you do a SELECT Statement that looks like:

SELECT DISTINCT [Field1], [Field2], [Field3], [Field4], [Field5], [Field6]
FROM yourTable

This would give you the actual number of valid combinations which would return at least one record.
OceanCityData Analyst Author Commented:
Thanks Dale, you explained it very well.  I'll share what I learned from you with the users.

Dale FyeOwner, Developing Solutions LLCCommented:
OP thanked Dale Fye for the explanations.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.