1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-ACCESS

  • Query to merge group heading to a column

    From miloann@21:1/5 to All on Tue Oct 17 11:30:56 2023
    Example:
    AAA
    123 John Los Angeles
    222 Lee Los Angeles
    BBB
    456 Mary New York
    555 Ann Houston
    CCC
    789 David Phoenix

    How to write a query to become:
    AAA 123 John Los Angeles
    AAA 222 Lee Los Angeles
    BBB 456 Mary New York
    BBB 555 Ann Houston

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)