How to filter witha where condition is a summ of fileds?
example "select filed1,filed2,filed3, from Table where summ of filed4+filed8+filed10<>0"
Tks.
Printable View
How to filter witha where condition is a summ of fileds?
example "select filed1,filed2,filed3, from Table where summ of filed4+filed8+filed10<>0"
Tks.
You have it... just too many words:
select filed1,filed2,filed3, from Table where filed4+filed8+filed10<>0
-tg
Hi tg all ok!
But i have see the query take a lot of time to extract the result!!!
Wath is the best code to open table and extract the valu of fileds in question...
Suggest me a good cursor a goo data type (KEYSET, DIRECT KEYSET ECC...)...
Note:
- i use acces database
- the number of value in fileds are approx 4.500.000
- i use tipcal ado conn
- the acces database is located on a server dir similar \\myserver\mydir\mydb.mdb
- i need only to read value in fileds
The same as you have been told multiple times before... if you need a reminder, read the FAQ article What do the parameters of the recordset.Open method mean? for some of it.