Hi Thanks arnelgp this worked for me but i was looking for output as shown in below it missed to mention month of billing.
invoiceno
billing month1
Amount1
billing month2
Amount2
billing month3
Amount3
123
jan
77
april
65
321
jan
34
feb
44
may
45
453
feb
89
mar
87
I am having the table where data with the same invoice number stored as shown in table 2 and I would like to display it as shown in table2
Table1 Table1
invoiceno
amnt
month
123
77
jan
453
89
feb
123
65
april
321
34
jan
321
44
feb
453
87
mar
321
45
may
Table2 Table2
invoice...
Dear Thanks for Your Efforts but the data is going to be more than 50,000 records using update commnd will affect the things and i already mention in my POST dont want to use UPDATE command
Checked That but still problem persist it is keeping previousl;y heckbox checked as well my condition is when say id1 is already selected and after that i slect the ID 4 id 1 checkbox should get cleared
I had created a multi item Form with the table as shown having a checkboxes .But If I select the checkbox all other chekcboxes should get clear only one can remain checked at a time. the form is shown below and code as well i dont want to use update query or for loop is there any way
Private Sub...