Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Fri Feb 7 11:00:01 CST 2003
Neal, you're right I didn't read the question carefully the first time, I thought that RequestorName is mandatory, it's a other way around > You need to parenthesize the RequestorName and the "/", else when > RequestorName is Null the whole thing will be Null because with your > version the & will evaluate first. > > (RequestorName + " / ") & BadgeNumber > > Neal Kling > > > -----Original Message----- > From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] > Sent: Friday, February 07, 2003 11:47 AM > To: accessd at databaseadvisors.com > Subject: Re: [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/ > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > 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/