Report help

  • Thread starter Thread starter Andy79
  • Start date Start date
A

Andy79

Hi, I am very new to access reports, so please excuse my ignorance of
the process..

I would like to make the follwoing report but am unsure how to do
this.

My data is very simple: table1 'events' [1>many] table2: reports

I wish to show the number of events each month (group by start date &
count the number of records)
Each records also has check boxes for some info: 'Report', 'incomplete
records', 'not relevant'
I wanted to count the number checks for each category and add this to
the 'view by month'

finaly for one of the categories (report) i also want to count the
number of reports in the reports table (this data is linked by a 1-to-
many relationship) and also count the number with a specific setting
in the reorts table

so my report would look something like this


Events. Report incomplete not relevant. Reports
obtained highstandard
Jan
10 5 4
5 4 1
Feb
20 xx xx etc...

do i need to make a series of quires for this? or can the report do
any counting of records?

Many Thanks
Andy
 
Can you provide your actual table and field names? Do you actually have a
table named "reports"? I couldn't live with that ;-) Are the "check boxes for
some info" mutually exclusive? Can only one be checked for any one record?

I would think your solution might be to group by month and sum the absolute
value of the check box fields.

BTW: you should read up on normalization. You have created a basic
spreadsheet with your multiple check box fields.
 
Back
Top