Search results

Hello, I want to delete the third digit for all records in a column, is there a query that I can use in design view to do this? for instance "ab 123" should become "ab123" Thanks a lot for all your help!

Hello, I have to link two tables with each other. In table 1 I have a column with codes (EP678686) that I want to link with a column in table2, however in table 2 the codes include spacebars (EP 678686). In order to be able to linke the two tables with each other, I first want to delete the...

Hello, I have a column in my database that contains years. Some cells are empty (a Null value). I want to replace these empty cells by a number (i.e. the year 2006), how can I do this using a query in design view? Thanks a lot for your help!

Hello, I want to create a new table with the use of a query (using an already existing table), however, there is a problem. I created the query and made a new table query, however, i can not run the query because in that case i get the following message: can not open table because someone...

Hello, I have a dataset in which there are two columns with numbers in it. For instance: Column A Column B 12 25 34 17 67 80 Now, in each row, I want to have the smallest number in column A and the largest in column B, so that I get the...