Making a single field from a few

[coastguard]

Hi,

I've inherited a data base which has the address details of our members spread across multi fields i.e. Add 1, Add2, Add 3, Post town, Post code etc.

Not all the fields contain information which means when I do a mail merge for address labels there are blank lines.

I would like to either be able to create a single field in the table (like a memo field for example) which contains all the address detail, or create a mail merge without blank lines.

If anyone can help, or has other suggestions, I would greatly appreciate them.

Regards

 

[jdraw]

From a relational design view, you store data at the atomic level where you can. By that, it means break down the address into specific fields.

When you want to "assemble" these fields for some purpose eg mail merge and remove the "empty fields", you create some logic to do so.

How you store and how you present data are 2 different things.

 

[coastguard]

Thanks Pat and Jdraw.

Both replies very helpful and not only for this question.

REgards and hope the rest of your day?? goes well.