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:
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/
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Save time and get your email on the go with the Yahoo Mail App
Get the beautifully designed, lighting fast, and easy-to-use, Yahoo Mail app today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar