<div>
You would normally do the sub-totals in the report itself, not in the sql for the report. &nbsp;Sub-totals in SQL can be very messy.<br />
<br />
The VB6 Report generator makes it very easy to add sub-totals for each major category in your report.<br />
<br />
AW<br />

</div>


You would normally do the sub-totals in the report itself, not in the sql for the report.  Sub-totals in SQL can be very messy.

The VB6 Report generator makes it very easy to add sub-totals for each major category in your report.

AW


<div>
As I understand it, obtaining sub-totals in the report is easy when you have a parent-child structure in the database. But in my case I happen to have a single table, i.e. only one table with no relationship. In such a case I have found no method in VB6's DataReport for sub-totals. If you know of any I would be glad to learn the details.
</div>


As I understand it, obtaining sub-totals in the report is easy when you have a parent-child structure in the database. But in my case I happen to have a single table, i.e. only one table with no relationship. In such a case I have found no method in VB6's DataReport for sub-totals. If you know of any I would be glad to learn the details.

<div>
what field do you want to sub-total on? &nbsp;What is the table structure.<br />
<br />
AW<br />

</div>


what field do you want to sub-total on?  What is the table structure.

AW


<div>
Thanks, it helped. - As a mattter of fact it solved my problem.<br />
The parent-child relationship which should have been done in the database is in this way done or simulated in the DataReport.<br />

</div>


Thanks, it helped. - As a mattter of fact it solved my problem.
The parent-child relationship which should have been done in the database is in this way done or simulated in the DataReport.


<div>
<div class="content wysiwyg-content">
Hi, I have a single table in Access from which I want to do subtotals using sql in DataReport (VB6). How do I write the sql-code?<br />

</div>
</div>


Hi, I have a single table in Access from which I want to do subtotals using sql in DataReport (VB6). How do I write the sql-code?


SQL-code for Subtotals in VB DataReport

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.