Search DaniWeb - slelect

HElpppppppppppppppppppp!!!!!1 17 Years Ago by Sroxx hey im making a database on licnese issuing authority now i want get data retrived frm da database ma access to list boxes but i want data only of the data which i slelect fmr da dtpicker can u plz suggest a code for this thx 2 slelect statement in 1 query..HOW? 15 Years Ago by jegham Hi all, I am fairly new when it comes to SQL... and i would like some help I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my queries 1st query: [code=sql]select count(serviceid) from serviceslog where serviceid='3' and partition not like '%… Re: 2 slelect statement in 1 query..HOW? 15 Years Ago by verruckt24 It is unclear what you exactly want to achieve. Bot hof your queries are identical. Re: 2 slelect statement in 1 query..HOW? 15 Years Ago by pritaeas Mean something like this? [code] select '1' as rownum, count(serviceid) as id from serviceslog where serviceid='1' and partition not like '%test%' and component not like '%test%' and component not like '%do not bill%' and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59' group by serviceid union select '2' as … Re: 2 slelect statement in 1 query..HOW? 15 Years Ago by Tulsa hi If you want all same fields for different id than you can use 'in ' with where clause. [code] select count(serviceid) as id from serviceslog where serviceid in ('1','2') and partition not like '%test%' and component not like '%test%' and component not like '%do not bill%' and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59' … Re: "Virus Alert" on my taskbar!! 18 Years Ago by tayspen Hi, and welcome to daniweb. Please run HJT again, and slelect [b]Do system scan only[/b]. Then tick these items. [… Re: "Virus Alert" on my taskbar!! 18 Years Ago by diman …]Hi, and welcome to daniweb. Please run HJT again, and slelect [b]Do system scan only[/b]. Then tick these items… Re: Connecting to a access database 16 Years Ago by abu taher you can do it very easily. just put a data control. in properties slelect connection type access (if you want to connect office 2000 or next version you need service pack 6). and select the location of file. and then in record source select the table. Re: Tables in excel 14 Years Ago by JhonMoney … opinon you should text format for that problem. For this slelect your data and go to Home tab Number group and… Re: HElpppppppppppppppppppp!!!!!1 17 Years Ago by techniner Ok, can you start by speaking English, then post some code so I can review this? Re: HElpppppppppppppppppppp!!!!!1 17 Years Ago by Sroxx i have following list boxes and this data is fetched from access on formload, this is the code just for fetching the data. f3 represents a date [CODE=vb]Private Sub Form_Load() With Adodc1 .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\project.MDB" .RecordSource = "Select * from …