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 ().


Robin Chapple

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

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,


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.


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:

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    (Yahoo! ID required)

<*> To change settings via email:

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

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


Posted by: Robin Chapple <robinski@westnet.com.au>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)



Tidak ada komentar:

Posting Komentar