Rabu, 16 Maret 2016

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: 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