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

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
DJPr0Asked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
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
 
peter57rCommented:
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
 
Gustav BrockCIOCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
DJPr0Author Commented:
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
 
DJPr0Author Commented:
Thanks gustav, that was it!
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.