Attached is a program with db. User interface is VB6 and db is Access 2000. The password for the db is 123.
I need the data report to be modified. I would like data to be displayed in groups on my report (group by state). At the end of each group,I would like to see the total number of records. At the end of the report, i would like to see a grand total of records displayed.
To run program:
Select db location and enter password. Select a start date and end date using the dtpickers. Click on the Update button. Click on an option on the left listbox, the center listbox gets populated. click on a record in the middle listbox the right txtbox gets populated. If you click on the print button under the left hand listbox, all those records are displayed in a report. The same occurs for the other print buttons. The same report is called for all three print buttons. The data is the only thing that changes.
I just want data to be grouped by state and get a total number of records per group and a grand total number of records. The report should print landscape.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 2000
VB 6.0
ADO 2.5
## Deadline information
11/8/2002 noon Eastern time