Re: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

Hello Celeste,

Sometimes changing names messes with the group/sort that is set up. did you check the group/sort at the bottom of the report in design view to make sure that the grouping is not showing "Expression" instead of the name you changed it to?

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of celestecpa <bcpatin@gmail.com>
Sent: Tuesday, September 1, 2020 2:07 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Query & Report by Grouped by Name and Sorted by Date

 

MS Access 365 Pro Plus

I have a query listing names, product number and dates.
I want to group by names, but when I run the report, it breaks on each date that is different.

I had this report working and then I changed the name of a field and it now prints name, product for one date, then goes to the next person. 

Please help.

Thanks you,

Celeste