Altering Data Display

[TheDeal56]

I tried to revive an old post in the "General" section with this question, but it doesn't look like many people are looking at it. I figured it wouldn't upset the posting gods too much if I posted it here, since the the question is concerning queries.

I'm starting out with an excel sheet that looks like this:

Company Name..........Employee
Jones Electric............Kyle Brown
Jones Electric............Chris Ford
Jones Electric............Matt Daniels

Is there a way for access to make it look like this?

Company Name..........Employee..........Employee 2..........Employee 3
Jones Electric............Kyle Brown........Chris Ford............Matt Daniels

Thanks a lot, guys. I'll be sure to link the old post to this one.

 

[georgedwilkinson]

Not sure exactly what you're trying to do (looks like one dimensional data to me). But I believe the answer to your question is answered by Access' help on "crosstab" queries. There is a crosstab wizard available in Access. I've never written a crosstab querie in Access but I have achieved similar results in Oracle and MySQL.

HTH.

 

[neileg]

Alternatively, this may be of use: http://support.microsoft.com/kb/210163/en-us

 

[Paul Buttress]

Hi

There is a quick way to do this without importing any data.

You will need to add another column to the spreadsheet - for exaple a count column (see attached)

Link the spreadsheet to your database and use the attached query to view the data

Hope this helps a bit - it's a very quick way to solve your problem.

Paul

 

[TheDeal56]

Thanks for the quick responses. I don't know if this helps, but my data is actually more like the example below. I have multiple companies with multiple employees. Thanks agian.

Company Name..........Employee
Jones Electric............Kyle Brown
Jones Electric............Chris Ford
Jones Electric............Matt Daniels
L&L Designs...............Joe Masters
L&L Designs...............Tim Hutchins

Is there a way for access to make it look like this?

Company Name..........Employee..........Employee 2..........Employee 3
Jones Electric............Kyle Brown........Chris Ford............Matt Daniels
L&L Designs...............Joe Masters......Time Hutchins

 

[TheDeal56]

That looks like exactly what I need. Thanks a lot, Paul!

 

[TheDeal56]

Would there be a way to automate the count column?