MS Access Reports
Just in case you do not know how to use a query:
In your database window, under "objects" select "queries"
Select "create query using design view"
Select the table (which contains the information you are interested - i.e - Sex, rating)
Press "Add", then press 'close'
To call for M, rating 1
For the first column, select 'sex' for the 'field'
Type in 'M' for criteria
For the second column, select 'rating"for field and type in '1' for criteria
save,
and go to datasheet view (icon on upper left)
a query table should show up, and at the bottom, there should be some numbers, the number is the number of records called by the query (i.e. your count)
to call for M rating 2, click on the design view icon (where you found the datasheet view icon)
under the second column where you have "1" as criteria, replace with "2".
Save... go to datasheet view
If you understand all of the above, you should be able to work your way through.
|