|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
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.
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
