N naobao Registered User. Local time Yesterday, 21:50 Joined Feb 13, 2014 Messages 99 Nov 15, 2018 #1 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!
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, 00:50 Joined Apr 9, 2015 Messages 4,354 Nov 15, 2018 #2 access doesnt really create data that way. Not with 2 columns. Crosstab queries require 3.
