Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    16

    Question Unanswered: Please Solve my problem!

    I have the following tables and fields.

    SBcnt Table:

    [SBNO]
    -----------
    013180
    013180
    013180

    above 3 are unique records

    SBnet Table:

    [SBNO ]
    --------
    013180
    013180
    013180
    013180
    013180
    013180

    [SBNOTOTAL]
    -------------
    3
    3
    3
    3
    3
    3


    above 6 records are also important for me but the SBTOTAL value 3 should not be repeat in all fields only first record shows value 3 in SBTOTAL and remaining 5 records shows value 0. like below

    [SBNO]
    ----------
    013180
    013180
    013180
    013180
    013180
    013180

    [SBNOTOTAL]
    -------------
    3
    0
    0
    0
    0
    0

    above example is required. How can i count and set the SBNO 3 unique records value=3 in SBNOTOTAL field first record and remaing records with 0 value.

    I have many records in SBNO field in SBnet Table with different value and want to count same from SBNO field in SBcnt Table and put the value into first record of SBNOTOTAL in SBnet Table.

    Please guide me and help me through example code. would be highly appreciated.
    Last edited by ishaqani; 03-04-07 at 11:05.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    No answer yet so this is not only a bump - but an oppurtunity for the originator to clarify the question because I personally don't have an idea what's being asked here.
    George
    Home | Blog

Posting Permissions

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