Are there ever more than 30 item codes that might be generated?
What is stored in your table that determines which item is numbered 1, 2, etc.
What is the reason for displaying in this format? Is this for a report, web page, form, query, or what?
Duane Hookom
MS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: mmabizer@yahoo.com
Date: Mon, 4 Jul 2011 07:04:51 -0700
Subject: [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]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)
<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Tidak ada komentar:
Posting Komentar