Multiple Column Help!

[kennybarlow]

Here's my dilemma. I work for a manufacturer, and I have been able to use access to pull all the raw data from our ERP. I have been able to create a query that shows me the model number, the work order numbers that were issued for that model number, all the individual step/operation numbers in that work order, and the times an operator was on each op/step.

What I want to do is format a report that sorts:
1. by model # (That I can do)



but then I want it to compare the all the op times of each work order issued on that model that week side by side.

So in my head it looks like this (sorry for the crude Paint work):

[June7]

Not really knowing your data structure makes it hard to give specifics. But your options may be:

1. CROSSTAB query - building a stable report to run perpetually based on CROSSTAB is not easy http://allenbrowne.com/ser-67.html

2. build a query for each work order then join all those queries to master dataset of steps/operations

3. query that emulates a CROSSTAB with expressions http://www.datapigtechnologies.com/f.../crosstab.html

4. temp table and VBA https://www.accessforums.net/program...ias-21972.html

5. concatenate related data into single string http://allenbrowne.com/func-concat.html

Doubt options 2 and 3 are practical because each model probably has different number of work orders.