Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,6-10

K

ken957

My database contains many tools bsed on wafer size and includes their age. I
do not need a count of each individual age, but rather want totals for ranges
of the tool age.
 
K

KARL DEWEY

Use the partition function ---
Segment: Partition([amount],0,25000,5000)

Segment: Partition([YourField],Start_Point,Maximum_Value,Increment)
 
K

ken957

I get a type mismatch error, the filed in the refrenced table is number. I
entered Partition([IBase Current]![test age update],0,20,5)
--
ken


KARL DEWEY said:
Use the partition function ---
Segment: Partition([amount],0,25000,5000)

Segment: Partition([YourField],Start_Point,Maximum_Value,Increment)
--
KARL DEWEY
Build a little - Test a little


ken957 said:
My database contains many tools bsed on wafer size and includes their age. I
do not need a count of each individual age, but rather want totals for ranges
of the tool age.
Click to expand...
Click to expand...
 
R

raskew via AccessMonster.com

What is the data type of your age field? The Partition() function works with
numbers. If your age field is text, that's a problem and would probably
generate the error you're encountering.

Bob

I get a type mismatch error, the filed in the refrenced table is number. I
entered Partition([IBase Current]![test age update],0,20,5)
Use the partition function ---
Segment: Partition([amount],0,25000,5000)
Click to expand...
[quoted text clipped - 4 lines]
Click to expand...
 
Top