Having statistics

[hamidchi]

Hi friends
--
I have a table that contains fields like gender , job , place of birth and .....

so I wanna have another table or query for knowing how many of each records
for example how many male or how many cashier are there in the main table
and if one male is added to the main table the statistic table would update automatically

=============
would you please help me how can i do that ?

[orange]

You really want a query -- specifically a SELECT query with a where clause.
You do not want those stats in a separate table. If you change anything in the first table, your second table would not be current. Better to use 1 table and a query (or several specific queries).

See this free youtube video for info.