[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/