Search results

thanks it worked!!

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!

Maybe it is easier for me to just delete the spacebar (3rd digit)? Is there a query that can delete a spacebar? (so that EP 678686 becomes EP678686)? Thanks a lot!!

This does not work, I get an error. should , be ; maybe? I tried this, but still another error: data type mismatch in criteria expression?? Anyone who can help me?

Thanks, but where should I put the code? I normally work with query in design view?

Thanks, but where should I put the code? I normally work with query in design view?

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

yes, it worked!! Thanks a lot!

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!

I already used a different name, that's the weird thing!

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

it worked, thanks a lot!

the programme Access does not regonize "if" ? I use: maek a query in design view and addes the if-function in the field like this: if([case1]>[case2], [case1], [case2]) but it does not work? did I enter the if in the right field?

but where should i put this if-function then? i normally use creating query in design view, can i put this if-function somewhere in the grid?

Dear Gemma, How can i do a query to set "highest" nad "lowest"? How should i for instance performe a query to set "highest" (out of the two columns per row)??? Thanks, Daniëlle

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