View Full Version : Report by ranges of data


endri81
10-29-2010, 04:51 AM
Hi I have a table like this:

MotherData
__________
Name
Age
Nationality
Education
NumberChildren
ProblemType

If Age is from 19 to 70 and Problem type from 740.00 to 759.99 I need a query for the report like this

Problem type Age
19-23 24-29 30-36
A
B
C
D
E
Where A,B,C,D are problems defined in ranges 740.00-742.15, 742.16-746.00.......
Report view should be like attached file

Trevor G
11-01-2010, 02:28 AM
Can you upload a sample of your table with data in it, which will give me something to work with.