You are here:

Using MS Access/duplicate rows query output

Advertisement


Question
untitled
untitled  
i have an access query that was exported to excel
this shows cath lab cases by number and procedure group with duplicates shown on separate rows.
is there a way to run the query to combine the duplicate procedure groups into one row? or a way to do that afte export to Excel?
ive attached shot of excel output. i had a way to combine the duplicates from another expert but couldnt get all the other columns to return after the combine.

Answer
You want to put all of the procedures together into one row? Same cell or multiple cells? Can you show me an example of what you want the finished product to look like?

I can't think of a quick and easy way to do this in Access or Excel without some kind of programming... so this may not be a quick solution.

Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
599CD Computer Training

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.