Solved

MS Access Need help with report not being able to sort users under date

Posted on 2013-06-19
6
357 Views
Last Modified: 2013-06-19
Please see attached database.

Run "frmReportByDate"
Input dates: 6/1/2013  -  6/30/2013
Click "Report"

Problem: I cannot get the user names to sort under the weekly date:
Dave
Dave
Dave
Nick
Nick
Joe
ReportTest---Copy.accdb
0
Comment
Question by:DJPr0
  • 3
  • 2
6 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 39259306
Your main sort is on Refdate - that's what you are getting.

If you want to sort on a calculated field then add the calculated field to the recordsource query and then it is available in the report as a standard field which you can sort.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39259348
That's not needed.

Your first sort is wrong. It is not the date but your grouping expression to sort on:

  =Format([refdate]-(([refdate]-2) Mod 7);"mmm dd")

The second sort is WEmployee.

/gustav
0
 

Author Comment

by:DJPr0
ID: 39259435
gustav - Did you post the correct grouping expression? The only difference is the semi-colon which gives me an error: The expression you entered contains invalid syntax.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39259536
Use a comma.

But the difference is that you didn't use that expression in the report's grouping and sorting.
You use it the group header but that's not enough.

/gustav
0
 

Author Closing Comment

by:DJPr0
ID: 39259654
Thanks gustav, that was it!
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39259761
You are welcome!

/gustav
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

863 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

19 Experts available now in Live!

Get 1:1 Help Now