I am not be as framiliar with Access as I would Like to be,

Would there be a way to have Each of the 50 criteria (14 possible enteries
for each of the 50) Entered or left with some type of interactive query?
Return the count of Values for each column of data along with the total
sample size and then divide to get a percentage while returning the total
sample size as in number of rows for user information?

Also While Making this user friendly for users of access who are not too
framiliar with the program?

"Myrna Larson" wrote:

I have an idea that this problem would be better solved with a query in
Access. Why does that not work for you?

On Tue, 13 Dec 2005 08:06:02 -0800, "Tim H"
wrote:

Hi,
I have a spreadsheet with approximately 30K rows of data and over 130 colums
wide. Currently I am doing multiple Dcounts with multiple criteria as a named
range
=dcount(worksheetname!a1:gg30000,fieldname1,works heetname2!a1:bb2)/dcount(similar
to previous string)
Looking for a way to shrink filesize or, more importantly, decrease
worksheet calculation time.
The named range (over 50 fields) criteria can have sevel different values in
each cell so permutations are many. With the criteria changing so often (and
often the sample size returned is a majority of the rows) is access a
feasibility?
Counting the total sample size after reduced by the criteria is also very
important.

Any Suggestions would be appreciated.

Best Regards,

Tim