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

Hi Celeste,

The "breaks" are controlled by the Sorting and Grouping in the report design. Can you provide additional information about how this is set up in your report?

Do you have a fields named "Name" or "Date"?

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of celestecpa <bcpatin@gmail.com>
Sent: Tuesday, September 1, 2020 4: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