Well. It seems like everytime I try to do something in Access, no matter how simple it would seem, there is ALWAYS a problem. GRR!

I want to create a single page report that displays calculation results (from a query) about each different category i have in my table/query. Maybe there is a way to just turn off the duplicating property of the details field all together? Nothing on this report will/should duplicate.

I did my research and discovered that i could change the "Hide Duplicates" property to YES and it does what I want. However, i've only found this property on a "Text Box". I also would like to apply that concept to: a line, a box, a table AND an image. But for these controls, this property is no where to be found, at least not in the same list that i found it in for a Text Box.



I commend you guys greatly for putting up with this gigantic pain-in-the arse program!

Is everything in the detail section a duplicate?

If yes, then you may need to update your query to return unique vakles or records.

If you only want to totals, then you may not need anything in the detail section, only in the group footer.

To be sure what will be the best way, we will need to know more about the report.

Everything in the details section should NOT duplicate, in fact, i don't really want anything on the entire report to duplicate. Can I turn it off?

The "stuff" in the details section is just a number crunching table showing different details (Ex. % of jobs on time, % of open jobs, total jobs by each person, etc.) about the Jobs table. The calculations for the most part are done on a query, so it's just a bunch of "data" plastered on a report. I have other reports that show this data individually and more in depth, this is just the overview.

So I should put everything in the Footer?