TIP: Click on subject to list as thread! ANSI
echo: visual_basic
to: All
from: Bob
date: 2004-01-29 06:00:00
subject: Counting columns in DataG

Hello 

I am using a datagrid which I populate with several different queries.
They depend on option buttons to determine which query is run. All of
the queries have the same constant the "Name" 

What I am trying to achieve is have the first or second column totaled
based on the name 
Example: 

In the grid it looks like this 

Name Part Amount Invoice DeliveryMethod 
Bob Motor 100.00 1000 Our Truck 
Bill Cam 200.00 1001 UPS 
Bob Plugs 29.00 1002 UPS 
Jeff Oil 3.00 1003 Will Call 
Bill Lube 2.50 1004 Will Call 
Bob Filter 4.99 1005 Will Call 


I would like for it to look like this 

Name Part Amount Invoice DeliveryMethod 
Bob Motor 100.00 1000 Our Truck 
Bob Plugs 29.00 1002 UPS 
Bob Filter 4.99 1005 Will Call 

Bob Count 3 

Bill Cam 200.00 1001 UPS 
Bill Lube 2.50 1004 Will Call 

Bill Count 2 

Jeff Oil 3.00 1003 Will Call 

Jeff Count 1 

Like Excel or something reasonably close. Is this even possible in a
grid?. I can throw it out to an excel file but I don't know how to put
it in the export process. 

Thanks 
Bob
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 1/29/04 6:00:46 AM
* Origin: MoonDog BBS, Brooklyn,NY, 718 692-2498, 1:278/230 (1:278/230)
SEEN-BY: 633/267 270
@PATH: 278/230 10/345 106/1 2000 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.