Show all the proc.dates in a query and only once the patients name

[error123]

Hi,

I would like to find out how many echo's one person had and show only one name and in a colum and show all the dates in the next colum.
Thsi is what I have so far:

SELECT Demographics.Last_Name, Demographics.First_Name, Demographics.Patient_ID AS ["MRN"], Event_Echo.EventDate, Event_Echo.ProcedureType, Event_Echo.PtDataInterpretingMD
FROM Demographics INNER JOIN Event_Echo ON Demographics.SS_Patient_ID = Event_Echo.SS_Patient_ID
GROUP BY Demographics.Last_Name, Demographics.First_Name, Demographics.Patient_ID, Event_Echo.EventDate, Event_Echo.ProcedureType, Event_Echo.PtDataInterpretingMD
HAVING (((Event_Echo.EventDate) Between #12/1/2006# And #12/1/2006#))
ORDER BY Demographics.Last_Name, Event_Echo.EventDate;

Is there a way to do this in Access?
Thank you!

 

[AlexCuse]

There most likely is. Can you show sample data from your tables, and expected result?

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[lespaul]

check out FAQ701-4233

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[traingamer]

Or you could just use that query as the basis for a report.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[error123]

How I wanted to do it, is exporting the query into Excell as a pivot table, than go from there.

LastName F_Nm ID# DateofProc ProcType DR.

Ban Anna 234 12/1/2006 XYZ drBarni
Ban Anna 234 12/4/2006 XYZ dr.Bela
Ban Anna 234 12/12/2006 GRE dr.Barni
Hun Eve 678 12/23/2006 XYZ dr.Barni
Hun Eve 678 12/24/2006 XYZ dr.Bubu


it would look like this:
Ban Anna 12/1/2006 XYZ dr.Barni
12/4/2006
12/12/2006
Hun Eve 12/23/2006
12/24/2006

Thank you!!

 

[error123]

Thank you for everyone. I got this one!