Aug 24 2005, 03:50 PM
I have a report where my boss doesn't want any groupings - just wants all contracts listed. Buy the contracts are associated with three different departments: Sales / Marketing / Services
Can I put text boxes in the report header that shows
Total Sales Contracts: 31 | Total Marketing Contracts: 72 | Total Services Contracts: 31
and then in the detail portion of the report simply show all contracts with no grouping ?
Aug 24 2005, 04:42 PM
I would probably do this with a subreport. Develop three queries that produce the desired totals. Then another query whose tables are the three totals queries. Then use that query as the record source for the subreport. The main report could be developed in the normal way.
Aug 24 2005, 04:47 PM
Thanks - that's too cumbersome, and my boss has since changed her mind, but thank you for confirming that this takes some work ! Good solution, though - thanks !
Aug 24 2005, 04:58 PM
Steve, you're welcome. If you wait long enough, perhaps she'll change her mind again!
Aug 24 2005, 05:10 PM
Women don't change their mind !
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here