|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Visual Basic Problem - 9/15/2005 16:20:48
Hi Everybody: Does anybody how to solve this problem?
First Query Result:
[Vendor] [Acc#] [Date1] [Paid1] [Date2] [Paid2]
Micro_____M1___1/2/05_$1
Micro_____M2_______________2/1/05__$2
Micro_____M1_______________3/1/05__$3
DHL______D1___4/1/05_$4
Second Query result, I want to make like this:
[ID] [Vendor] [Acc#] [Date1] [Paid1] [Date2] [Paid2]
1____Micro___M1___1/2/05_$1
2____Micro___M2________________2/1/05_$2
1____Micro___M1________________3/1/05_$3
3____DHL____D1___4/1/05
Why do I want to add ID field, because I want to do like this:
Query:
Select [id], [Vendor], [Acc#], min([Date1]),min([Paid1]),min([Date2]),min([Paid2])
From Second Query result
Group by [id],[Vendor],[Acc#];
Then it will show like this:
[Vendor] [Acc#] [Date1] [Paid1] [Date2] [Paid2]
Micro____M1___1/2/05_$1_____3/1/05_$3
Micro____M2________________2/1/05_$2
DHL_____D1___4/1/05
I will hide the Id column.
I want to reduce the row. The problem is that how to make the number in the id field, and also make the same number if the vendor name and Acc# is same the previous before.
Please help me to solve it. Thanks. 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 
k¥ 
