Search results

can you please direct me to the thread..it would be very helpful indeed Thanks

Thanks for the reply, then what I want to do is show ONLY when the query is run a 100 Because this is the ename with the lowest Salary. Another query is to show the third lowest value, i.e., c 300 Thanks and sorry for the confusion

Hallo, I have the following table (Table1) ename salary a 100 b 200 c 300 d 400 and am supposed to bring the minimum salary value and ename, when a query is run. The following SQL syntax brings...

Please help!!!

Hallo, I have a checkbox on a datagrid and on loading the form is set to True (checked) with the code below which works well. For irow = 0 To DgvToPay.Rows.Count - 1 DgvToPay.Rows(irow).Cells(3).Value = True Next irow What am trying to do is when the checkbox is unchecked then the next...

My datatype in the database is varchar(50). I expect it to write either a Yes / No in the respective data field. Thanks

Hallo, I am working with VB.net 2005, what am trying to do is insert fields into a table in Sql database. The table name is TblQuarPay The following code works perfectly well but it doesn't populate the field ToPay in the database. Quoting Error encountered can't change varchar to numeric...

Hallo, I have a checkbox which I called ToPay (design name), this checkbox is unbounded with other bounded fields in a datagrid called DgvToPay. Also note, When the form is loaded the datagrid is populated and the checkbox checked always (i.e,. threestate set to True). What I want to do is...

Thanks anyway JR

Is this in VB.net 2005. Because i wanted to change the desin name to Me.chk3 but it says Me.chk is not a valid identifier. I named it ToPay before Thanks

Hallo, I have a checkbox which I called ToPay (design name), this checkbox is unbounded with other bounded fields in a datagrid called DgvToPay. Also note, When the form is loaded the datagrid is populated and the checkbox checked always (i.e,. threestate set to True). What I want to do...

Hallo, I am working with VB.net 2005, what am trying to do is insert fields into a table in Sql database. The table name is TblQuarPay The following code works perfectly well but it doesn't populate the field ToPay in the database. Quoting Error encountered can't change varchar to...

Both the values in A B C are empty. I have used the trim() function but it never worked it still brinngs forward empty columns. any idea? Thanks

Hi, I am working with access 2003, I have one table with three fields A, B and C. I am trying to write a query whereby if A=B it should be displayed with the respective C data. For example Bsc Mathematics = A Bsc Mathematics = B 4 years course = C In the above example A = B, so C will...

Thanks worked

In the design view, in the criteria section I typed <> A2, Access automatically makes it <> "A2" and still brings all the records even when A1 = A2 Thanks

so in the criteria part, I will type Select from sess_0607 (table name) where A1 <> A2

Hallo, I have a table with two fields A1 and A2. Both of these feilds contain text such A1- MA Psychology and A2 - MA in Psychology. If you notice A2 has an "in" word in between MA and Psychology. I want to write a query where by only if A1 <> A2, then the fields are brought forward i.e...

Hallo, I have a table called sess_tbl with two fields, A1 and A2. Both fields have full description in text format. They should be similar, however some fields are not the same. How can I write a query to compare between the two fields and bring forward fields which are same and/or not the...

Thank you guys it has been sorted the problem was at the bounding column Many thanks