Results 1 to 2 of 2

Thread: MS Access, ?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User bai_vlado's Avatar
    Join Date: Sep:2005
    Location:
    Posts: 2,290

    MS Access, ?

    :
    Access, . , , .
    :
    - 1,2,3,4,6,7,8,10,11,12,14,15,16...... .. 5,9 13. Querie, , - , - ; ..
    . , :
    1,4, 6,8, 10,12, 14,....... .
    Excel IF, ...

  2. #2
    Automatic Jack
    Join Date: Feb:2004
    Location:
    Posts: 216
    , , . 97 . , . - ID- ID, v .
    SELECT t1.v
    FROM Table1 t1, Table1 t2, Table1 t3,
    t1 left join t2 on t1.v-1 = t2.v ,
    t1 left join t3 on t1.v+1=t3.v
    where t2.id is null or t3.id is null

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |