Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have a table with address fields (split into 5 fields)
I have a formula that looks something like this:
IIF(addr_1=space(30),"",addr_1+", ")+IIF(addr_2=space(30),"",addr_2+", ")...
which I have found to work on other occasions. However in this instance it seems to be failing, it is only displaying first lines of adresses, and in some instances, only the first few characters. Can anyone shed light on why this might be happening and suggest a way to stop it?
Ta
Sha
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement