VB6 and MS Access Problem

[xwings]

I just learn how to do a programming with vb6, and i have few problem that i need to get some advise and idea from experts here.

Ok I successfully captured a data from a notepad text, and my access database data filed is look like this;

Schedule sku size inseam total
112206 92221 32 32 40
112206 92221 32 32 12
112205 92221 40 32 8

I decided to make an output to the text format (Notepad) also; I already made the layout of my output suppose to look like this;

Schedule# SKU Inseam/Size 32 33 34 35 36 37 38 40 42 44 Total
112206 92221 30
112206 92221 32 52
112206 92221 32

Schedule# SKU Inseam/Size 32 33 34 35 36 37 38 40 42 44 Total
112205 92221 30
112205 92221 32 8
112205 92221 32

my question is how can I add the “total” if the “schedule”, “sku” , “size” and Inseam” are same? Thanks

[guru511]

[How can i access data from MS Access using VB6 (I need the connection code) can u plz tell me the code for accessing tables in MS Access using Visual Basic 6. my access tables are in a server not in my local computer..... plz let me know the code

[QVeen72]

Hi,

In ur original Text file, if all the parameters are "Sequential", then u can keep a Running Total and print the Total If Parameters of Next line Changes, and then Re-Set the Total

REgards
Veena