Adding ANOTHER Grouping Level?
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
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
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?
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
and then the rest of the orders with a single SKU can preceed that as:
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
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:
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.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Adobe Shockwave and Flash Player Upgrades [Anwsered],Troubleshooting:After auto sleep shutdown, computer won't start back up Error,Solution to Error: adding a month to a date using a formula,How to Fix Problem - Aero Peek being black?,Solution to Error: Advanced Conditional Sum help for Excel 2007,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded