Adding ROW function in VBA that can get data from Access

[Skinny1434]

Hello all, sorry if this topic has been discussed before, this is my first post on the forum. I am very novice with VBA, and currently I am stuck on a certain problem. I have a ton of data, that is currently stored in Access, it used to be stored in Excel but it made the workbook run very slow. I have a table in access that has many different values for the same customer name. i.e.

Customer A 2000
Customer A 5000
Customer A 1000

Before I switched the data over to Access, I used a INDEX>ROW function that gave me all the values related to Customer A. What I am wondering now, is if there is a way to do the same with an access table. I currently have a connection to the Access table, and I am using a DBVlookup, however, I need to be able to return more than one value. Any help would be great!!

 

[Trevor G]

You would select the Data Menu and then Pivot Table or Pivot Chart then step through the guide if you are using Excel 2003 or lower.

You would select the Insert Tab and Pivot Table is on the left hand side if you are using 2007 or 2010.

You can always search YouTube on how to create a Pivot Table.

http://www.youtube.com/watch?v=7zHLnUCtfUk

Once you have created something you can work with then post back if you need help with setting the page option up.

 

[Skinny1434]

Alright thanks man, I'll give it a shot and post back.