Senin, 04 Juli 2011

[MS_AccessPros] Vertical data in Horizontal form

 

Hi All

Im working in a company where there are 30 products.
Each salesperson sales many items each day..
My data base looks like this

SP IDDATEITEM CODEQUANTITY
30012312/06/201124023
30012312/06/201128052

30012312/06/201135011

30015412/06/201124023

30015412/06/201136132

30035012/06/201145115

30035012/06/201159091

30035012/06/201119527

I want to make a query that displays each salesman's daily record in a row..
like this

SP IDDATEITEM CODE1QUANTITY1ITEM CODE1QUANTITY1ITEM CODE1QUANTITY1
30012312/06/2011240232805235011
30015412/06/20112402336132
30035012/06/2011451155909119527

I shall be grateful if any one helps me out..
Thank you very much

Abizer

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar