[AccessD] Remove extra characters concatenate

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