Search results

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

hi i try this: BEGIN TRANSACTION INSERT INTO TermNumTbl(TermNum) VALUES ('5') COMMIT TRANSACTION but i get error how to write TRANSACTION in access ?

hi i have field `Tdate` (text type) on my Table `MyTbl` i need query that sort by date, i try this: select * from MyTbl order by Tdate **but because Tdate is Text i get wrong results** how to fix it ? is there any convert to date in access ? thanks in advance

hi i have this table Discount: from | to | Dis 1 | 50 | 10 51 | 80 | 20 81 | 99 | 30 99 |120 | 40 and i have this work table MyTable: id | sum | dis 123| 22 | 222| 85 | 131| 85 | how to fill the dis field in MyTable ? that the table will look like this: (if the sum between the...

hi i have table in access that has an automatic counting in field `ID` after some insert rows the `id = 200` i delete the table i try to insert a new row - and i see that the id start with `201` how i can force the `id` to start with `1` (without drop the table and make new) thanks in...

hi i have this table: MEN Fname | Lname AA | AA1 BB | BB1 CC | CC1 i need to add column ID and Numbering from 1 to the end MEN Fname | Lname | ID AA | AA1 | 1 BB | BB1 | 2 CC | CC1 | 3 **i need it in SQL Syntax not with design...