[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Creating a comma separated list as a Function to be used in a Totals/Group By query

Posted on 2009-12-30
Medium Priority
Last Modified: 2013-11-27
I would like a function that I can use in a Totals/Group By query in Access where this:

Truck   SONum
WC     234567
WC     233555
EC      236666
EC      235777

becomes this when grouping by Truck:
Truck      SONumCSV
WC         234567, 233555
EC          236666, 235777

I found this, but I'd rather have a function that I can just use in the aggregate within a Totals/Group By query.

Can someone help?

BTW, Happy New Year!

Question by:Stephanie Hudson
  • 2
LVL 10

Expert Comment

ID: 26148372
are you querying Access DB or are you using only Access interface to query a MS SQL database?

Author Comment

by:Stephanie Hudson
ID: 26148512
It's an Access database.
LVL 41

Accepted Solution

Sharath earned 2000 total points
ID: 26148808

Author Comment

by:Stephanie Hudson
ID: 26149310
This is good.  I think I can make this work.  Thanks!

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question