Date as a label's caption is fine; its only as an object name that it might
cause problems.

Have you tried combining grouping and setting the MoveLayout property to
False in code as described in my last post? That should work with the
simplified layout you posted, but if you need something more complex you
might be better off breaking it down into a parent report for the incidents
and subreports for the multiple values per incident. That would give you the
most flexibility as you can position the subreports anywhere you like in
relation to each detail row of the parent report.

Ken Sheridan
Stafford, England

Lee Ann wrote:
The hide duplicates may work on a small scale, however it hides too much if I
have other records with the same information. The sorting/grouping also
doesn't seem to give me the format I'm looking for.

The use of the word Date was mentioned - this is a caption on the report,
but the field name is actually DateofIncident. Does the same rule apply in
this case?

As always, thanks for all the advice you guys give!

In the Report Sorting and Grouping dialog (View Sorting and Grouping),
group by Date, then Location. Create a group header for each. Place a text
[quoted text clipped - 34 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201004/1