Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-06-19
6
Medium Priority
?
399 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 52

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 52

Accepted Solution

by:
Gustav Brock earned 2000 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 52

Expert Comment

by:Gustav Brock
ID: 39259761
You are welcome!

/gustav
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

572 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