Whats wrong with this code

[colmoore]

Hi all,

Successfully managed to get the following to work:

=[SALUTATION] & " " & [FIRST NAME] & " " & [SURNAME]

But when I try a similar trick with the email and Date of Birth fields it doesn't work. I'm using:

="Email " & [EMAIL ADDRESS]

and

="Date of Birth " & [DATE OF BIRTH]
??????????

 

[WayneRyan]

col,

What does it do? Or not do?

Wayne

 

[colmoore]

Error

Hi there,

I'm just getting #Error where the email address should be.

Any ideas???

 

[colmoore]

Thanks

Pat,

Thanks so much, your advice has solved the problem

Regards

Col Moore