- check the cause of zero returned value for the field of total transaction field in the textfile
- as per checking of the query, the grand total is not included in the extraction query
- modify the query and add the extraction of a total of the transaction
- test the modified application, and as per checking it's still not reflecting the value in the textfile
- modify the application again to add the total transaction fields in the inserting of data in MDB from MySQL
- test the application again and as per checking it is now reflecting the value
- check extracted data in the text file and compare it to database data
- as per checking all the data extracted is tally to the data in the database