I'm tasked with replicating in Access a particular report running in a Filemaker database. The output should look like this:
NAME DATE ITEM(S) Joe 5/2/2012 Gum Tape Soap Ann 5/1/2012 Paper Bob 5/1/2012 Pen Paper
where the records look like this (it's a query joining the "person" and "items" tables, which have a 1:many relationship):
NAME DATE ITEM(S) Joe 5/2/2012 Gum Joe 5/2/2012 Tape Joe 5/2/2012 Soap Ann 5/1/2012 Paper Bob 5/1/2012 Pen Bob 5/1/2012 Paper
In the report, I need the first ITEM always to show up in the first, complete row; if there are more items, only the items should be listed in subsequent rows (the NAME and DATE values should not be repeated).
I'm not quite sure which tree to bark up:
The only thing I've managed so far is to group on the person, with the NAME and DATE in the Group Header, and then put all of the items in the detail, but that's not exactly what I have been asked to do.
Thanks in anticipation of "a-ha!".
Chris