You can, with a Pivot Table, certainly treat those numbers, 1, 0, and -1 as
though they are text, and put the fields into a row or column field and get
counts, etc., and express those counts as a percentage of the row or column,
etc.

But filtering is another matter. Pivot Tables don't give you much control
there. One workaround is to set up a "flag" column that contains a 1 if data
is to be included, 0 if not, etc.


On Thu, 15 Dec 2005 10:39:02 -0800, "Tim H"
wrote:

Thank you for your input so far Myrna,

All of the fields contain numerical data, the first few columns containing
date and type information with most of the rest of the columns containing
numbers which signify certain kinds of occurences.

For Example in column A37 = 02/15/2001
If more rain fell on 02/14 than 02/15 the value in column CG37 would be 1,
less rain and -1, same rain 0 and no rain blank

one column has all 1's in it to give a total sample count, the dcount will
count all the non blank cells, therefore giving one number over the other to
get a probability. This is why i dont think a pivot table will work, the
critieria will be changing contantly to get different outputs as well as a
nonblank cell in field count/total sample size is required.

Any more ideas on how to attack this? All your help is very much appreciated.

Best Regards,

Tim

"Myrna Larson" wrote:

Probably, but one would need to know what the fields are in the table, what
the criteria look like, and what you are trying to count. Possibly a Pivot
Table (which you can do from either Access or Excel) would eliminate the
need
for a query, since you can get totals for all values in the field at once.

On Tue, 13 Dec 2005 19:29:02 -0800, "Tim H"

wrote:

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