var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concatenate Components
I am trying to get my reports looking a bit nicer. I read that I can do
I took the Iif statment out also [suffix] and i get "#Error?". So I tried the long way..
=[FirstName] & " " & Iif([MiddleName], [MiddleName] & " ","") & [LastName] & " " & [Suffix]
Now I get "#name?" what's going on?
=Employees!FirstName & " " & Employees!LastName
what's the name of the textbox you're trying to put this in?
The textbox name is LastName
Here you go...let's say you have these field names:
FirstName, MiddleName, LastName
to contatenate (combine them) do this:
FullName:[FirstName]&" "&[MiddleName]&" "&[LastName]
That's all there is to it. You can do that in the Query as well as creating a field in the Form.
Also, if you want either Comma's or Dashes in between, just place them between the double quotes as such:
have a nice one,