ACCESS FEED: RE: [MS_AccessPros] Text in a "Text" field

Kamis, 17 Maret 2016

RE: [MS_AccessPros] Text in a "Text" field

Thanks Duane,

The text box is in the Zone header. If I add the field 'leader' it displays as needed.

I have removed the ().

Regards,

Robin Chapple

At 18/03/2016 12:48 AM, you wrote:

Robin,
Which section of the report contains the text box? I would expect it to be in the Zone Group Header. If the text box is in the Report Header it would display the values from the first record.

I'm not sure why you are using ()s in the expression. Also, since the query is the record source of a report, the ORDER BY Data.Unit does nothing.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 17 Mar 2016 17:05:27 +1100
Subject: Re: [MS_AccessPros] Text in a "Text" field

Thanks Duane,

That cured the problem. I have now expanded the field to show the Zone Leader's name. The report is grouped on Zone. The Zone Leader is in a separate table.

SELECT ZoneLeaders.Zone, Data.Unit, ZoneLeaders.Leader, ResidentsCombined.Resident, ResidentsCombined.Phone
FROM (Data INNER JOIN ZoneLeaders ON Data.Zone = ZoneLeaders.Zone) INNER JOIN ResidentsCombined ON Data.ID = ResidentsCombined.ID
WHERE (((Data.Unit) Is Not Null))
ORDER BY Data.Unit;

This is calling the first resident present in the report.

="Zone " & ([Zone]) & " " & ([Leader])
What have I missed this time?

Many thanks,

Robin

At 17/03/2016 03:19 PM, you wrote:

You didn't tell us what you mean by fails. I think you only need to change the name of the text box.

Duane

Sent from Outlook Mobile

_____________________________

From: Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < ms_access_professionals@yahoogroups.com>

Sent: Wednesday, March 16, 2016 5:17 PM

Subject: [MS_AccessPros] Text in a "Text" field

To: < ms_access_professionals@yahoogroups.com>

I have been away from Access for eighteen months and my memory is

suffering 'old timers' disease. I need to add the letter Z to a field

called Zone.

This fails.What have I missed?

="Z " & ([Zone])

Many thanks,

Robin Chapple

------------------------------------

Posted by: Robin Chapple <robinski@westnet.com.au >

------------------------------------

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:

    http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:

    Individual Email | Traditional

<*> To change settings online go to:

    http://groups.yahoo.com/group/MS_Access_Professionals/join

    (Yahoo! ID required)

<*> To change settings via email:

    MS_Access_Professionals-digest@yahoogroups.com

    MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:

    MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:

    https://info.yahoo.com/legal/us/yahoo/utos/terms/