Automating Reports

B

Bromdon

Hi.

I'm trying to write a report for my employer and, well, I'm not an
Access guru so I don't even know if this can be done.

Essentially, I want to be able to produce a report which will produce
weekly totals for the whole of the year, the figures being the counted
number of true fields from various tables.

How do I write a report that will carry figures for weeks 1 to 52?

How do I count true entries in different fields, most of them ANDs?

Sorry if this is a little unclear, but if someone can point me in the
right direction then that'd be cool.

TIA
Bromdon
 
D

Duane Hookom

A WAG suggests this can be done with a crosstab query. Counting True values
is the same as Summing the Abs() of the yesno expression/field.
 
Top