João serras-pereira

<div>
Can you provide some more detail about your data, and what you want to display, maybe via an Excel spreadsheet.
</div>


Can you provide some more detail about your data, and what you want to display, maybe via an Excel spreadsheet.

<div>
Yes. I am pasting the query<br><br>
</div>


<div>
Oops<br><br>You may see: there are several users and each user has several messages,<br>So I should have a list and, for the list, I have the sub list...<br><a href="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450553/q07_mensagensEnviadas.xlsx" rel="ugc">q07_mensagensEnviadas.xlsx</a>
</div>


Oops

You may see: there are several users and each user has several messages,
So I should have a list and, for the list, I have the sub list...
q07_mensagensEnviadas.xlsx [https://filedb.experts-exchange.com/incoming/2020/04_w17/1450553/q07_mensagensEnviadas.xlsx]

q07_mensagensEnviadas.xlsx

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
On my app I need to provide a form similar to report, where I am able to aggregate and break according to certain fields. It is possible. Can anyone help?<br />
<br />
The basic idea is to provide a clearer view, instead of repeating the same content all over...
</div>
</div>


Hi

On my app I need to provide a form similar to report, where I am able to aggregate and break according to certain fields. It is possible. Can anyone help?

The basic idea is to provide a clearer view, instead of repeating the same content all over...

aggregate firlds in form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.