Concatenate 3 fields on the reports

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

How can we concatenate 3 fields like First name and Middlem name and
LastName, so that it will not take many spaces on the report, Also I have 3
fields of address, and I want to combine address1, address2 and address3. All
are intended not taking a lot of spaces, so that we have a nice looking
report.

Thanks in Advvance

Frank
 
In a query, create a new field, something like:

FullName: [FirstName] & " " & [MiddleName] & " " & [LastName]

You could use a similar approach on the address fields. If some address
fields are empty, consider using one control per field, and setting the Can
Grow and Can Shrink properties to "Yes" to close up space.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Thanks very much Jeff, it helps me a lot, but on the addresses side since I
want to make it automatically moves to the next line, otherwise evenlandscape
is not enough space, could you educate me, how can I make it?, for expample

FullName Address baptisedby datebaptized ....etc etc
---------- --------------- ------------ -------------- -------
------
Soetarjo Jl. Antena no4
Radio Dalam
Jakarta Selatan

I want it if I make the same approach, the next letters will automaticaly go
below

With many thanks
--
H. Frank Situmorang


Jeff Boyce said:
In a query, create a new field, something like:

FullName: [FirstName] & " " & [MiddleName] & " " & [LastName]

You could use a similar approach on the address fields. If some address
fields are empty, consider using one control per field, and setting the Can
Grow and Can Shrink properties to "Yes" to close up space.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Frank Situmorang said:
Hello,

How can we concatenate 3 fields like First name and Middlem name and
LastName, so that it will not take many spaces on the report, Also I have 3
fields of address, and I want to combine address1, address2 and address3. All
are intended not taking a lot of spaces, so that we have a nice looking
report.

Thanks in Advvance

Frank
Click to expand...
Click to expand...
 
You might need to use sub-reports to get different pieces organized like
that.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/


Frank Situmorang said:
Thanks very much Jeff, it helps me a lot, but on the addresses side since I
want to make it automatically moves to the next line, otherwise evenlandscape
is not enough space, could you educate me, how can I make it?, for expample

FullName Address baptisedby datebaptized ....etc etc
---------- --------------- ------------ -------------- -------
------
Soetarjo Jl. Antena no4
Radio Dalam
Jakarta Selatan

I want it if I make the same approach, the next letters will automaticaly go
below

With many thanks
--
H. Frank Situmorang


Jeff Boyce said:
In a query, create a new field, something like:

FullName: [FirstName] & " " & [MiddleName] & " " & [LastName]

You could use a similar approach on the address fields. If some address
fields are empty, consider using one control per field, and setting the Can
Grow and Can Shrink properties to "Yes" to close up space.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Frank Situmorang said:
Hello,

How can we concatenate 3 fields like First name and Middlem name and
LastName, so that it will not take many spaces on the report, Also I
Click to expand...
have
3
fields of address, and I want to combine address1, address2 and
Click to expand...
address3.
All
are intended not taking a lot of spaces, so that we have a nice looking
report.

Thanks in Advvance

Frank
Click to expand...
Click to expand...
Click to expand...
 
Back
Top