Search results

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

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...

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...

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...

hi i have this table MEN Name ____ aaa bbb nnn aaa aaa nnn i need to erase all duplicate rows (but leave only the first) Name ____ aaa bbb nnn i need any query that do it

I have an Access 2007 database file that should be used by two programs simultaneously. Program 1 should insert and update the table; Program 2 should only run queries to show the data. The problem is, when program 2 opens the file - program 1 cannot insert or update rows. What can I do?

hi i have access file and when i try to open i got this error: You do not have the necessary permissions for this object XX... Ask the administrator or user who created this object to create the appropriate permissions for you is there any way to open it ? or any tool for this ? thank's in advance

hi is there any tool or add-on for write color and comfortable query on access-2007 ? thank's in advance

hi if my computer region set to dd/MM/yyyy hh:mm and my query in access: select * from MyTbl where MyDate between #25/12/2010 10:51# and #30/12/2010 12:11# is this query will work on computer that his region set to MM/dd/yyyy hh:mm ? if no, how to fix it without change the region in the...