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.......
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.......
