Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    China
    Posts
    4

    Post Your help on visual basic 6 is higly appreciated

    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 thin 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

  2. #2
    Join Date
    Jul 2006
    Location
    China
    Posts
    4
    I need your help for vb as soon as possible...before deadline of my project please..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •