Recent content by hans37

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

Thank you for your solution. It works. But it does not solve the whole problem (which is more complicated). See therefore an ohter question of me "how to specify a specific join in a query". But again, thanks.

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