Calculations

M

mylove

I have 1 column in 1 table with 2 different #'s. Say 1 (man) & 2 (female).
i have to calculate 1 & 2 separately onto the same table.
 
D

Dennis

Not sure what you mean 'separately onto same table' ?
If you want to know how many men and how many women in the table then
create a query and put your column in twice. Click on the totals button on
the toolbar. Leave column 1 as Group By and change column 2 to Count.
Run the query.
 
Top