|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 18th, 2008, 10:16 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,6-10
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. -- ken 
|
|
#2
July 18th, 2008, 10:29 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,6-10
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" wrote: 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. -- ken
|
|
#3
July 18th, 2008, 11:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,
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" wrote: 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" wrote: 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. -- ken
|
|
#4
July 19th, 2008, 10:49 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,
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 ken957 wrote: 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) [quoted text clipped - 4 lines] do not need a count of each individual age, but rather want totals for ranges of the tool age. -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
