Kamis, 17 Maret 2016

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


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