I use ado and vb6 classic and access database...
in table have:
Field1 Field2 Field3
AAA BBB -100
AAA CCC 100
AAA BBB 100
AAA BBB 100
.....
based the goup by Field1 and Field2 i need to delete a pair of recorset where the algebric summ of filed3 is =0
in this my case delete this two recordset:
AAA BBB -100
AAA BBB 100
to the and of query i need to have this result:
AAA CCC 100
AAA BBB 100
i hope understand me....
Tks.
algebric summ with a pair of values
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
Re: algebric summ with a pair of values
sorry for upsal21 wrote:I use ado and vb6 classic and access database...
in table have:
Field1 Field2 Field3
AAA BBB -100
AAA CCC 100
AAA BBB 100
AAA BBB 100
.....
based the goup by Field1 and Field2 i need to delete a pair of recorset where the algebric summ of filed3 is =0
in this my case delete this two recordset:
AAA BBB -100
AAA BBB 100
to the and of query i need to have this result:
AAA CCC 100
AAA BBB 100
i hope understand me....
Tks.
-
- Administrator
- Posts: 78541
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: algebric summ with a pair of values
Does the table have a primary key, for example an AutoNumber field?
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78541
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: algebric summ with a pair of values
If there is a primary key, I know how to do this in Access itself, using queries, but not using VBA.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
Re: algebric summ with a pair of values
no.HansV wrote:Does the table have a primary key, for example an AutoNumber field?
-
- Administrator
- Posts: 78541
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands