Combine rows into one notes column

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Is there a way to combine totals and combine other columns into notes field?

What I mean by this is:

Sub CN COGS US CODE
123 3543685467 1.93 5E1 Non-Published Service
123 3543685467 15.16 23R 2 Wire Loop
123 3546071680 15.16 23R 2 Wire Loop


So, my end results would be
Sub CN COGS Notes
123 3543685467 17.09 5E1 - Non-Published Service, 23R - 2 Wire Loop
123 3546071680 15.16 23R - 2 Wire Loop

Thanks for any help
 
Keith said:
Is there a way to combine totals and combine other columns into notes field?

What I mean by this is:

Sub CN COGS US CODE
123 3543685467 1.93 5E1 Non-Published Service
123 3543685467 15.16 23R 2 Wire Loop
123 3546071680 15.16 23R 2 Wire Loop


So, my end results would be
Sub CN COGS Notes
123 3543685467 17.09 5E1 - Non-Published Service, 23R - 2 Wire Loop
123 3546071680 15.16 23R - 2 Wire Loop
Click to expand...


You need to create a function to do that.

Assuming you use the function available at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16

the query could look something like:

SELECT Sub, CN, Sum(COGS) As TotalCOGS,
Concatenate("SELECT US & ' - ' & CODE FROM table WHERE
Sub=" & Sub)
FROM table
 
Back
Top