X-Received: by 2002:a05:6214:320b:b0:66d:2854:90a8 with SMTP id qj11-20020a056214320b00b0066d285490a8mr64501qvb.3.1697567704177; Tue, 17 Oct 2023 11:35:04 -0700 (PDT) X-Received: by 2002:a05:6830:905:b0:6ba:3da9:bf53 with SMTP id v5-20020a056830090500b006ba3da9bf53mr1084606ott.3.1697567703983; Tue, 17 Oct 2023 11:35:03 -0700 (PDT) Path: csiph.com!tncsrv06.tnetconsulting.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-access Date: Tue, 17 Oct 2023 11:35:03 -0700 (PDT) Injection-Info: google-groups.googlegroups.com; posting-host=144.166.55.174; posting-account=UJZ3-goAAAA3juC42oL8Xw37Rl6smPhP NNTP-Posting-Host: 144.166.55.174 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <7a3728a7-0944-4c3c-a134-d73de9f04a49n@googlegroups.com> Subject: How to write query to merge group heading to a column From: miloann Injection-Date: Tue, 17 Oct 2023 18:35:04 +0000 Content-Type: text/plain; charset="UTF-8" X-Received-Bytes: 1359 Xref: csiph.com comp.databases.ms-access:14544 Example: AAA 123 John Los Angeles 234 Mary San Jose BBB 345 David San Franscisco 346 Lee Berkely 333 Ann New York CCC 555 Linda Houston How to write a query to become: AAA 123 John Los Angeles AAA 234 Mary San Jose AAA 345 David San Franscisco BBB 346 Lee Berkely BBB 333 Ann New York CCC 555 Linda Houston Thanks