Better Help

[jb]

I've got several problems designing reports bound to
complicated queries. I created a perfect report, then
when I saved and reopned, suddenly I'm getting asked for
Parameters for fields I never set them up for. Access
Help is very cryptic on many topics.
- How do I create a "calculated field" showing the sum
of all fields in a filtered table or query? This can't go
in a record, it would seem to me, but could only exist in
a report. I don't remember how I finally got a total
filed to show on the report - guesswork, Access Help just
didn't say.
- How do create a field that will count all the records
ina filtered table?
Please give detailed directions or point me to a
detailed KB article.

 

[Gary Miller]

To get a sum for a group of records put an unbound textbox in the group
footer or the report footer (for all records) and set the ControlSource to
be... =Sum([YourFieldName]).

If you want a count of all of the records, do the same as above and use the
Count function... =Count([YourFieldName])

Not enough info to help with the Parameter problems.

Gary Miller