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: Robin Chapple <robinski@westnet.com.au>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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