I need the "order by" to be in the group id field (sector_id) in the report.
I make the clients report (tbClient), related to two tables, where the sector table (tbSetor) is the group, and the table (tblocal) is the subgroup. I need to use the sector_id field as order by of the group. I made the query and when opening the correct relation appears, but when opening as a report the order is done with the field sector_description. This sector_description field is what you see in the report.
[resolvido] Repórter order by in group
Moderador: Avelino Sampaio
- Avelino Sampaio
- Mensagens: 1895
- Registrado em: 04 Jun 2015, 18:27
- Contato:
Re: Repórter order by in group
Hi Nilton
Open the report in Design view
Click the Design tab of the ribbon.
In the "Grouping and Totals" group, click the "Group and sort" button
Open the report in Design view
Click the Design tab of the ribbon.
In the "Grouping and Totals" group, click the "Group and sort" button
==================================================
Clique no link abaixo e veja um ótimo kit de ensino que tenho para você.
http://www.usandoaccess.com.br
==================================================
Clique no link abaixo e veja um ótimo kit de ensino que tenho para você.
http://www.usandoaccess.com.br
==================================================
Re: Repórter order by in group
I was able to solve it, with a simple explanation, short and fast.
It was a week ago and I could not get help on how to solve it. I am very grateful.
It was a week ago and I could not get help on how to solve it. I am very grateful.
Quem está online
Usuários neste fórum: Nenhum usuário registrado e 2 visitantes