[AccessD] Remove extra characters concatenate

NameBadge:
=IIF(IsNull(RequestorName),BadgeNumber,RequestorName&"/"&BadgeNumber)
 
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
(SELECT * FROM users WHERE clue > 0) 

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com] 
Sent: Friday 2003 Feb 07 10:31
To: '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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030207/caf5d443/attachment-0002.html>