Results 1 to 3 of 3

Thread: Sql Query

  1. #1
    Join Date
    Dec 2008

    Sql Query

    i want to make a query::::
    plz help

    i have a table:::: temp

    A B
    1 a
    2 a
    3 a
    4 a
    5 b
    6 b
    7 b
    8 a
    9 a
    10 b
    11 b

    i want the output to be

    From to B
    1 4 a
    5 7 b
    8 9 a
    10 11 b

    so plz help me......i m not getting the answer

    i have made like this

    select min(A),max(A),B from temp group by B;

    but it is giving me

    1 9 a
    5 11 b

  2. #2
    Join Date
    Mar 2006
    Oklahoma City, OK
    You might be able to do this with a sub query.

    It is possible to write some VBA code to loop through the data and write the results to a temp table.
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

  3. #3
    Join Date
    Aug 2008
    could you attach your db...

Tags for this Thread

Posting Permissions

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