1

Topic: Count of the data

Dear experts help please as and report table to make count. It is necessary 1). Only 2). them from 0-3 years 3). 3-6 years
4) All . Thanks for the answer!

2

Re: Count of the data

NovLaymer;
The age should be a numerical or monetary field since for "" () the text "11" <"3"

3

Re: Count of the data

I am sorry not that put

4

Re: Count of the data

SELECT Count (Tablitsa1. [The code]) AS Vyrazhenie1
FROM Tablitsa1
UNION ALL SELECT Count (Tablitsa1. [The code]) AS Vyrazhenie1
FROM Tablitsa1 where Tablitsa1. [Age] <=3
UNION ALL SELECT Count (Tablitsa1. [The code]) AS Vyrazhenie1
FROM Tablitsa1 where Tablitsa1. [Age]> =3 and Tablitsa1. [Age] <=6
UNION ALL SELECT Count (Tablitsa1. [The code]) AS Vyrazhenie1
FROM Tablitsa1 where Tablitsa1. [Employment] = '  ';

Made as in a condition
0-3 years
3-6 years