List of Values with Select Query

Jlayne

Obviously a 'Group By' in a select query will show me all the values that exist for field.

Is there any way to show the result in a single row (concatenated) rather than multiple rows?

Normal Group by Example results in the following:
Requisition # Invoice #
PR1021 DJ0002
PR1021 DJ0015
PR1021 AB0156

I would like to see the following result instead:
Requisition # Invoice #s
PR1021 DJ002;DJ015;AB0156

Thank You for your help.

ADezii

Quote:

Originally Posted by Jlayne

Obviously a 'Group By' in a select query will show me all the values that exist for field.

Is there any way to show the result in a single row (concatenated) rather than multiple rows?

Normal Group by Example results in the following:
Requisition # Invoice #
PR1021 DJ0002
PR1021 DJ0015
PR1021 AB0156

I would like to see the following result instead:
Requisition # Invoice #s
PR1021 DJ002;DJ015;AB0156

Thank You for your help.

I'm pretty sure that I can come up with a code-based solution if you are interested, just let me know. If you are interested, how would you like to see the results? (Debug Window, Text File, Table, List Box, Combo Box, etc.)? I'll check back later since there is probably a better, SQL based solution, but unfortunately I'm not the go-to SQL Guy! (LOL)!

FishVal

Producing a List from Multiple Records

Jlayne

Thank you both. This is exacly what I needed.

jason

List of Values with Select Query

re: List of Values with Select Query

re: List of Values with Select Query

re: List of Values with Select Query

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about