Concatenate 3 fields on the reports

[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

 

[Jeff Boyce]

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]

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

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/

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

 

[Jeff Boyce]

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/

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

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/

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