Change Query Data Format (1 Viewer)

N

naobao

Registered User.

Local time

Today, 13:40

Joined

Feb 13, 2014

Messages

76

• Nov 15, 2018

• #1

How to use modules to convert query from A format to B format?

A Format
101001 A2
101001 A8
101001 C1
101001 D12
101002 B12
101002 C1
101002 J10

change to...B format
101001 A2, A8, C1, D12
101002 B12, C1, J10

Thanks!

 

isladogs

MVP / VIP

Local time

Today, 21:40

Joined

Jan 14, 2017

Messages

18,212

• Nov 15, 2018

• #2

Hi naobao
See if the attached crosstab query is any use to you.
If not, then it will need the use of vba.

 

Attachments

• Naobao.zip

  28 KB · Views: 40

Minty

AWF VIP

Local time

Today, 21:40

Joined

Jul 26, 2013

Messages

10,371

• Nov 15, 2018

• #3

Have a look at Allen Browne's concat related function here: http://allenbrowne.com/func-concat.html

 

N

naobao

Registered User.

Local time

Today, 13:40

Joined

Feb 13, 2014

Messages

76

• Nov 15, 2018

• #4

isladogs said:

Hi naobao
See if the attached crosstab query is any use to you.
If not, then it will need the use of vba.

Click to expand...

I have many records in query, crosstab is too many fields...
I think vba is good to me.

Thank you so much!

 

Gasman

Enthusiastic Amateur

Local time

Today, 21:40

Joined

Sep 21, 2011

Messages

14,260

• Nov 15, 2018

• #5

I'd be looking at Minty's suggestion?