Recent content by E_Gold

thanks for the help, but val(string) work fine only for numbers. if i try val(A000123) i'll get 0 how to remove zero for not only numbers ?

hi how to remove zero from the begining of a string in access by query ? for example: 00001234 -> 1234 000abc -> abc thanks in advance

thanks for the help, but i cant see something that will help me

hi i neet to numerate my table from 1 to when ID change. for example i have this table: ID | Name ====== 11 | AA 11 | BB 11 | CC 11 | DD 22 | EE 22 | FF 33 | GG 33 | HH 33 | AA 33 | DD 44 | ZZ and i need to see this: NUM | ID | Name ============ 1 |11 | AA 2 |11 | BB 3 |11 | CC 4...

it Text field

i sort by the first column

it will be like this MEN === AA | 1010 | 1 BB | 2020 | 2 CC | 3030 | 3 CC | 4040 | 4 DD | 5050 | 5

is there any solution for this ? i only need to add column that contain numbers from 1 - to the end of the table

hi i have table MEN with field name and ID (not unic) like this: MEN === AA | 1010 BB | 2020 CC | 3030 DD | 4040 how to run any query that can add column that has numerator ? like this: MEN === AA | 1010 | 1 BB | 2020 | 2 CC | 3030 | 3 DD | 4040 | 4

hi i try to reverse string on access in sql query and C# like this: SQL = "SELECT StrReverse(Des) from MyTbl"; dsView = new DataSet(); adp = new OleDbDataAdapter(SQL, Main.Conn); adp.Fill(dsView, "MyTbl"); adp.Dispose(); dataGridView1.DataSource = dsView.Tables["MyTbl"].DefaultView; and i...

Thanks !!!! its work !!!!

i need to count where the qty>0 and where the qty=0 like this: i have this table Serial | Qty | NewQty ============== 700 | 1.3 | 0 700 | 4.2 | 4 700 | 9.3 | 0 700 | 5.5 | 5.3 900 | 1.1 | 0 900 | 2.2 | 5.3 i need to see this Serial | count1 | count2 ===============...

hi i have 2 tables: A: serial , Name , Memo B: serial , Name , Memo i have another table: C: serial , Name , NewName , Memo , NewMemo , Status i need to fill table C in this condition: 1. A:Name = B:Name and A:Memo = B:Memo -> insert to table C and status = 0 2. A:Name <> B:Name or...

i got error on my access query SELECT CounterG.barcode, CounterG.qty, CounterG.Des, Items.barcode, Items.numH, Items.Des FROM Items INNER JOIN CounterG ON replace([Items.Des]," ","") = replace([CounterG.Des]," ","") ; i got error on: replace([Items.Des]," ","") how to fix it ?

hi i have table MEN in access that contain unique key generation (auto increased field) when i insert record to database, this field increase. how to read this value ? is there way to read this value when i insert the record ? thanks in advance