Change query data (1 Viewer)

naobao

Registered User.
Local time
Today, 01:46
Joined
Feb 13, 2014
Messages
76
litem Loc
101001 A2
101001 A8
101001 C1
101001 D12
101002 B12
101002 C1
101002 J10

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

Thanks!
 

Ranman256

Well-known member
Local time
Today, 04:46
Joined
Apr 9, 2015
Messages
4,337
access doesnt really create data that way.
Not with 2 columns.
Crosstab queries require 3.
 

Users who are viewing this thread

Top Bottom