Concatinating two fields..

[#1]

Hello,

Which is the best way to concatenate two fields from a same table. For ex. I have two FName and LName in the table of the database MS Access, I want to load it and display it as the FullName field in QV report.

Thanks N Regards..

Ravi

[#2]

Load FName , LName , FName & ' ' & Lname as FullName
from yourtable

jj