Report Sorting and Grouping

[singleton2330]

Hi.
I have developed a database for my stock control and have dual locations on some of my stock codes.
In my reports I want Stock codes with dual locations to appear twice in my reports in correct location order. At the moment I only have them in order of Location 1 and location 2 prints next to it.
If a stock code has a Primary location of BinA and a second location of BinK I want the stock code Second location BinK to print after BinJ
Any help?

[June7]

I don't understand data structure. How does location 2 print next to location 1?

If you want to provide db for analysis, follow instructions at bottom of my post.

[singleton2330]

12345678910

[singleton2330]

Attachment manager?? advanced post editor??? sorry! New to this place. Cant get the db below 2.62

[June7]

Click Go Advanced below the Quick Reply editor window. Attachment manager is below the Advanced editor window.

Zip is still more than 2MB? Alternative is upload to fileshare site like Box.com and post link to file.