Rabu, 20 Januari 2016

RE: [MS_AccessPros] Old timer problem

 


Many thanks Duane. That fixed it.

Regards,

Robin Chapple

At 21/01/2016 01:28 PM, you wrote:

 

Robin,
Try:
 
NameFull: [LastName] & ", " & [FirstName] & ",(" + [PartnerFirstName] +")"
 
Duane Hookom, MVP
MS Access
 
> From: MS_Access_Professionals@yahoogroups.com
> To: MS_Access_Professionals@yahoogroups.com
> Date: Thu, 21 Jan 2016 09:30:32 +1100
> Subject: [MS_AccessPros] Old timer problem
>
> I have been away from Access work for more that a year and age has
> warped my memory.
>
>
> I nee to add the field "PartnerFirstName" to a query and I have
> failed. I cannot even find an example from another database.
>
>
> This is my failed attempt:
>
>
> NameFull: [LastName] & ", " & [FirstName] & IIf([PartnerFirstName] Is
> Null," ",(" [PartnerFirstName] "))
>
>
> What have I missed?
>
>
> Many thanks,
>
>
&gt
; 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)

.

__,_._,___

Tidak ada komentar:

Posting Komentar