A Specific Type of Access Report

message from =?Utf-8?B?TGF1cmE=?= on 20 May 2004

I have a reporting need to summarize the details from one table. The end user will need to enter 2 pieces of information that will be used to limit the amount of information reported. The reported information will appear on the same form the 2 pieces of filtering data are entered.

The information for the report will come from 1 table. The table will have data entered from various users. The data comes from either option button groups with 3 values: yes, no, na; or yes/no check box fields.

All that needs to show on the report form is a summary of the data on the table based on date span and user name. By summary, I mean a count of “yes”, “no”, “na” from option groups, and “yes” or “no” from checkboxes.

I have tried PivotTables, Crosstab queries, DCount statements based on queries, but to no avail. I cannot seem to limit the report to the 2 bits of information-name and date.

I am trying to avoid writing code, so any help on how to do this without coding would be helpful. Of course if there is a place that may have pre-written code that may help solve my problem, that would be good too.

Thanks

Nikos Yannacopoulos replied to =?Utf-8?B?TGF1cmE=?= on 21 May 2004

Laura,

Though you're not very specific on your table structure, by what you're
saying I would guess that the most appropriate way to about it is a plain
Select query with Totals to do the counting, not pivots or crosstabs. Make a
Select query with Totals turned on, make it Group By on user name and option
group / yes/no fields, use any field to Count on and Where on the dates so
you can apply your date filter.

HTH,
Nikos

"Laura" <laura.lindley@twc.state.tx.us> wrote in message
news:74A9E84D-9090-4293-961F-1162498C365C@microsoft.com...
user will need to enter 2 pieces of information that will be used to limit
the amount of information reported. The reported information will appear on
the same form the 2 pieces of filtering data are entered.
data entered from various users. The data comes from either option button
groups with 3 values: yes, no, na; or yes/no check box fields.
table based on date span and user name. By summary, I mean a count of
“yes”, “no”, “na” from option groups, and “yes” or “no”
from checkboxes.
queries, but to no avail. I cannot seem to limit the report to the 2 bits of
information-name and date.
coding would be helpful. Of course if there is a place that may have
pre-written code that may help solve my problem, that would be good too.

Archived message: A Specific Type of Access Report (MS Access Database)