Solved

Sorting in a Access Report

Posted on 2014-01-13
2
159 Views
Last Modified: 2014-01-13
I have a simple report that looks like
  C Smith
                  store           paygroup    paycompany  notes



The powers that be wish me to have the store numbers sorted by ascending. Fine. Now the want me to the the notes field which denotes "Closed" Put them at the bttom of the first store and have those in ascending order. I can get the stores in asceding order but when U try to do the second sort exeything is mix up
0
Comment
Question by:Serena2345
  • 2
2 Comments
 
LVL 5

Assisted Solution

by:mebaby333
mebaby333 earned 500 total points
ID: 39776927
Have you tried to set the two fields next to each other? try moving the note field to the right of the store field
0
 
LVL 5

Accepted Solution

by:
mebaby333 earned 500 total points
ID: 39776939
Access I believe sorts from left to right so it will try to sort the columns in between...
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
InternetExplorer object in Excel VBA. 4 21
Auto Adjust Percent rate 5 30
Excel - SQL export question 3 0
min values in series 13 0
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now