Combine Fields (Easy one) (1 Viewer)

[rgreene]

How do I combine 3 name fields?
I have 3 seperate fields LName (Last Name - Public), FName (First Name - John), and MIName (Middle Initial - Q). How do I get Reports, Forms, and/or Lookups to display in 1 field Public, John Q

Thanks
Rick

 

[scottfarcus]

Set the control source of the appropriate field to:

=LName & ", " & FName &" " & MIName