field within label

[Nikki]

Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:

 

[strive4peace]

Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Nikki]

Perfect Thanks!

Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:

 

[strive4peace]

you're welcome, Nikki happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Perfect Thanks!

Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:

 

[mike]

Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

enter this into a text box..

="Bearing from " & [Daughter Site] & " to Parent Site:"


Regards,
M Woods,
==============
www.fruitchat.co.uk
www.software-illusions.com