Query question

[Carol]

Hello -

I have people in a database that have multiple dates
attached to their records. For instance, one person can
have three different "diary" dates associated to their
case. I want to write a query that shows the person's
name ONCE and the three dates in separate columns.

Right now when I run the query, it shows me the person's
name all three times along with the dates. Is there any
way to restrict this so it shows the name once and the
dates in the following columns without showing the name
all three times?

Thanks!