Post reply

how to find a missing set of sequence against a particular set of value

  • November 6, 2007 at 5:24 am

    #69281

    my table name is cTBl would be

    nbox- indicates the box number

    fruits - indicates the fruits type

    nbox------ fruits

    1----------orange

    2----------apple

    2----------orange

    2----------lemon

    5----------orange

    4----------apple

    6----------lemon

    I would like to find the missing sequence of numbers against each fruit item

    it should be like this should be like this

    orange 3,4

    apple 1,3

    lemon 1,3,4,5

    I just cant fiGure out the sql code for it , i am a beginner in the field

    i asking this so i can generate report on access based on it , please do help out

    please do help

    I just cant fiGure out the sql code for it

    please help out ........

    thanks in advance

  • November 9, 2007 at 8:17 am

    #749870

    You could create another table with all of the values required. then do a view or query with that table linked to your data table. Then query for nulls.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply