|
accessman -> MS ACCESS problem (9/15/2005 14:22:41)
|
Hi:
MS Access 2002 version:
I got the result of the query:
Vendor Name Acc# Date 1 Paid 1 Date 2 Paid 2 Date 3 Paid 3
Micro --------E123--1/2/05 $1
Micro --------E123-----------------------2/2/05 $2
Micro --------E888-----------------------1/2/05 $3
Micro --------E123----------------------------------------2/3/05 $4
Micro --------E888--1/3/05 $6
DHL ----------D11---1/2/05 $1
DHL ----------D11------------------------2/2/05 $2
DHL ----------D23---1/2/05 $3
DHL ----------D23-----------------------------------------2/3/05 $4
DHL ----------D11-----------------------------------------1/3/05 $6
.....
So, how can I change like this in report/query:
Micro E123 1/2/05 $1 2/2/05 $2 2/3/05 $4
Micro E888 1/3/05 $6 1/2/05 $3
DHL D11 1/2/05 $1 2/2/05 $2 1/3/05 $6
DHL D23 1/3/05 $3 1/2/05 $4
..
Thanks for helping me. Thanks.
|
|
|
|
