Search results for query: *

I have the following problem. I have a string with different surnames seperated by " ". I want to make a function that gives me the first letter of the second surname (In reality what I want to do is more complex). I made the following function: Public Function...

I want to use the VBA "replace" funtion in an ordinary expression in a query. In the list build in functions there is no "replace" function. What should I do?

How to specify a specific join in a query? I have three tables: members, membersupdate, countries. The tables members and membersupdate are have the same fields and are connecter throug an inner join on membersid. Both tables have a field which contains a code for the country members live in...

Concatenation simple? For the sake of simplicity i have two tables: members and countries. The table countries consists of two fields: code, countryname. For each member in the table members there is a field countrycode. It contains the code (a number) but displays the countryname. This is...