Avi Converter: How Can You Fix - Adding ANOTHER Grouping Level??

Adding ANOTHER Grouping Level?

Hello,

I Need to add another "Level" of grouping to a report, but can't seem to get it to work the way I want it to work.

We're a wholesale/manufacturer of children's footwear, we have online customers that send us CSV Files that contain the orders for the weekend or day or hour...
I use access to Import those CSV Files into a table and I print the orders so the warehouse can pull them, it also exports the table into Excel format onto a Networked Computer for easier shipping.

Many of these online "Consumers", people like you and me, may order 1 or 2 pairs of shoes.
I have the report setup to group by customer name with a new page at the end of these "Groups".

To make it faster for our warehouse, they are requesting it be sorted by Style # or SKU when they print out.
I've tried many things, the only thing that actually works is Grouping it by SKU, Then By CustomerName.
But then it puts the same customer on two different
pages...

How can I keep the same CustomerName on the same page while having it sort by SKU #.

I've tried Grouping it by CustomerName, then adding a Sort By SKU but that doesn't work...
If 1 customer orders more than 1 pair, it does sort it numerically on that page, but I want them all sorted by SKU, while keeping the CustomerName grouped on the same
page.

How can i do that?

I've also tried, Grouping by CustomerName, then adding a group under that for SKU, but that doesn't work either...

Thanks for all ur help, if you need more info, let me know.

Anwsers to the Problem Adding ANOTHER Grouping Level?

Download Error Fixer (Free)

You need to decide whether you want to pull an entire order for each customer or pull each SKU regardless of customer. If your example included only orders with multiple SKUs where no two orders have exactly the same SKUs. For example, what if you had
these orders:
Sam 1
         2
         3
Joe   1
         2
         4
Mary 2
         3
Sue 1
        3
        4
and then the rest of the orders with a single SKU can preceed that as:
6   Fred
     George
7   John
     Pat
     Polly
That requires a tricky record source query for the report. I think it might be vaguely like:
SELECT customer, SKU, ...,
               (SELECT Count(*) FROM thetable As X
                 WHERE X>customer = thetable.customer) As CustSKUs
FROM thetable
and use an expression like this in the report's Sorting and Grouping:
   =IIf(CustSKUs = 1, SKU, customer)
Now decide if you want them sorted that way or this way:
1 Sam
    Joe
    Sue
2 Sam
     Joe
    Mary
3 Sam
    Mary
    Sue
4 Joe
    Sue
etc.

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.
Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
Type or copy paste the below command line into it without quotes:
"Sfc /scannow"

Another Safe way to Repair the Problem: Adding ANOTHER Grouping Level?:

How to Fix Adding ANOTHER Grouping Level? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.