I take an opportunity to say hello for all members of this community.

Hey guys,

I have a problem for database I develop, to tell u frankly am new on vb languages. Highly appreciated your help on this matter.

I have a table look like this

ID ---orderID----Grandtotal ----Revenue
1 --- 2 ------- 100 ---------- 500
1--- 3 ------ 100----------- 500
1--- 4------ 200------------500
2--- 5------ 600 ----------1000
3--- 6------ 200 --------- 2000

I want to limit the Revenue field only one time if the ID repeated
Its means if the ID reapeated what ever the value of Revenue, it will be executed once and the rest will be zero. Show the table base on the first table above as ur references.

ID ---orderID----Grandtotal ----Revenue
1 --- 2 ------- 100 ---------- 500
1--- 3 ------ 100----------- NULL or 0
1--- 4------ 200------------NULL or 0
2--- 5------ 600 ----------1000
3--- 6------ 200 --------- 2000
I need your help soon. Pleas