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

  • Thread starter Thread starter ken957
  • Start date Start date
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.
 
Use the partition function ---
Segment: Partition([amount],0,25000,5000)

Segment: Partition([YourField],Start_Point,Maximum_Value,Increment)
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making age group query work 7
How to merge data from different fields in a crosstab query 1
Help needed - want to count categories within a category on a repo 5
Combine crosstab with other query info 3
Queries across tables, merging/concatenating 0
Group by Range in Crosstab Query 4
Total SUM in crosstab query 2
Crosstab Query - Recalculate totals after each date 2

Back
Top