[AccessD] Remove extra characters concatenate

Hollis,Virginia HollisVJ at pgdp.usec.com
Fri Feb 7 10:32:00 CST 2003


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/4e9232b7/attachment-0001.html>


More information about the AccessD mailing list