[AccessD] Remove extra characters concatenate

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Fri Feb 7 11:00:01 CST 2003


Neal,
you're right I didn't read the question carefully the first time, I
thought that RequestorName is mandatory, it's a other way around

> You need to parenthesize the RequestorName and the "/", else when
> RequestorName is Null the whole thing will be Null because with your
> version the & will evaluate first.
>
> (RequestorName + " / ") & BadgeNumber
>
> Neal Kling
>
>
> -----Original Message-----
> From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> Sent: Friday, February 07, 2003 11:47 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Remove extra characters concatenate
>
>
> Virginia,
> I am almost sure u can do it this way --
> RequestorName + (" / " & BadgeNumber)
> thats what I think I did.
>
>> could you use the IIf statement like below in your Query:
>>
>> IIf(isnull(RequestorName),BadgeNumber,RequestorName & "/" &
> BadgeNumber)
>>
>> Paul
>>
>>
>>
>> From: "Hollis,Virginia" <HollisVJ at pgdp.usec.com>
>> Date: Fri 07/Feb/2003 16:31 GMT
>> To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
>> Subject: [AccessD] Remove extra characters concatenate
>>
>> I am concatenating two fields Name / badge for a report, this is done
> in
>> the query.
>>
>> RequestorName&" / "&BadgeNumber
>>
>> In reports if the requestor is Null, I do not want the slash between
> the
>> name & badge number to show. How can I have the / not show for null
>> requestors?
>>
>> Virginia
>>
>>
>>
> ________________________________________________________________________
> __
>> Freeserve AnyTime - Go online whenever you want for just £6.99 a month
>> for your first 3 months, that's HALF PRICE! And then it's just £13.99
> a
>> month after that.
>>
>> For more information visit http://www.freeserve.com/time/ or call free
>> on  0800 970 8890
>>
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
>
> -----------------------------------------
> Send a Xuppa Valentine to Your Sweetheart today!
> http://www.xuppa.com/greet/
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Send a Xuppa Valentine to Your Sweetheart today!
http://www.xuppa.com/greet/





More information about the AccessD mailing list