<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>I am concatenating
two fields Name / badge for a report, this is done in the
query.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>RequestorName&"
/ "&BadgeNumber</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=380322616-07022003>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?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=380322616-07022003>Virginia</SPAN></FONT></DIV></BODY></HTML>