How to write query to merge group heading to a column

Newsgroups	comp.databases.ms-access
Date	2023-10-17 11:35 -0700
Message-ID	<7a3728a7-0944-4c3c-a134-d73de9f04a49n@googlegroups.com> (permalink)
Subject	How to write query to merge group heading to a column
From	miloann <miloann2002@yahoo.com>

Show all headers | View raw

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

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar

Thread

How to write query to merge group heading to a column miloann <miloann2002@yahoo.com> - 2023-10-17 11:35 -0700
  Re: How to write query to merge group heading to a column Philip Herlihy <PhillipHerlihy@SlashDevNull.invalid> - 2023-10-20 12:04 +0100

csiph-web