Reorganize dataset OR is there another way using a possibly long and complex query?

[tutlay]

I have a dataset where a customer has a unique ID but have multiple orders. Therefore, each customer ID has multiple order numbers. That's understandable and that makes sense.

My problem lies in the fact that the dataset is organized by order numbers -- NOT by customer ID. So, it looks something like this (there are way more columns than the five shown here).

Order#	CustomerID	OrderDate	Orderqty	Paid
1	10011	8/17/2002	7	Yes
2	10015	1/23/2009	22	Yes
3	10011	3/30/2003	11	Yes
4	10022	9/01/2005	28	Yes
5	10011	4/01/2005	4	Yes

The dataset has about 3,000 CustomerID with over 7,000 Order#. I need to analyze this data based on CustomerID so my gut tells me to first re-organize this set by CustomerID. Is that true? Or is there a way to do my analyses without doing this?



I'm more familiar with SQL but have [mildly] worked with visual basic and macros in Access 2010/2013 before.

[June7]

What kind of analysis?

Record order in table is irrelevant. Use a query and set whatever order you want.

Build a report using Grouping & Sorting features with aggregate calcs in group and report header/footer sections. This will allow display of detail records and summary calcs.

BTW, should not use spaces or special characters/punctuation (underscore is exception) in naming convention.

[tutlay]

Thank you, June7. I did just that and it worked for the most part...