crosstab query with field value first+last record

[barby.pava]

hi
i have a crosstab query


date Runreserved expr1 ([petname] & " " & [ownerl])
column row first

now in a family can have 2 dogs that goes in the same runreserved but using the first value it shows me only the first pet. i need to have this

-------03/20-----03/21------03/22
g/1 ---ted red--- ted red ----ted red
-------rosie red---rosie red --rosie red