hi all!
am enhancing a vb6/ms access/crystal report application
used for voting(mdb resides on one machine).
the app runs on 2 networked machines.
the data entry,therefore will be done in 2 simultaneous
batches...A & B.i have a control_no field in the same table.
Eg:For batch A, i give starting control_no=1
For batch B,starting control_no=11
Let us assume there are just 20 ballot papers.
first entry in batch A gets control_no=1.
first entry in batch B gets control_no=11.
A1 has an attribute x.if B1 has the same attribute x,
i save it as A1 (i.e tho' actual batch is B, it will be saved by the program as batch A,control_no=1).this is true even if it is the Nth entry in batch B.
this applies vice versa to batch A also.
my algorithm is able to group the entries with similar attributes Eg: A1,A2,A3,A4,A5,B14,B14,A6,B15,A7
A1,A3,B11,B12,B13,B14,B15,B16,B17,B18
u may observe tht only A1 to A7 and B11 To B18 are utilized.
* the crystal report should be able to print in sequence
A1,A1,A2,A3,A3,A4,A5,A6,A7,B11,B12,B13,B14,B14,B14,B15,B15,
B16,B17,B18
* summary column should give a count of 20
COntraint: we cannot give the same batch name A & A as this conflicts with simultaneous entries into database.
how do we achieve this objective?
regards,
bluebyte
am enhancing a vb6/ms access/crystal report application
used for voting(mdb resides on one machine).
the app runs on 2 networked machines.
the data entry,therefore will be done in 2 simultaneous
batches...A & B.i have a control_no field in the same table.
Eg:For batch A, i give starting control_no=1
For batch B,starting control_no=11
Let us assume there are just 20 ballot papers.
first entry in batch A gets control_no=1.
first entry in batch B gets control_no=11.
A1 has an attribute x.if B1 has the same attribute x,
i save it as A1 (i.e tho' actual batch is B, it will be saved by the program as batch A,control_no=1).this is true even if it is the Nth entry in batch B.
this applies vice versa to batch A also.
my algorithm is able to group the entries with similar attributes Eg: A1,A2,A3,A4,A5,B14,B14,A6,B15,A7
A1,A3,B11,B12,B13,B14,B15,B16,B17,B18
u may observe tht only A1 to A7 and B11 To B18 are utilized.
* the crystal report should be able to print in sequence
A1,A1,A2,A3,A3,A4,A5,A6,A7,B11,B12,B13,B14,B14,B14,B15,B15,
B16,B17,B18
* summary column should give a count of 20
COntraint: we cannot give the same batch name A & A as this conflicts with simultaneous entries into database.
how do we achieve this objective?
regards,
bluebyte