[AccessD] SQL Challenge!!!

Yep that should work...why didn't I.....(smile)
Thanks Gustav
Hey, how did the week away go?  Seems you must have recovered now....?
Kind regards,
David 

Engines2Go - Now THAT's a Search Engine!
Automated major search engine manager
Makes searching quicker and easier - Have you tried it? 
http://www.engines2go.com/  
http://www.cheqsoft.com/  The home of Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.
----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Saturday, August 23, 2003 8:43 PM
Subject: Re: [AccessD] SQL Challenge!!!


Hi David

You could do something like:

  SELECT
    IIF([Company]='Company',Null,[Company]) AS RealCompany,
    ...

/gustav


> Hi all
> Is it possible to do an SQL which filters out individual default fields and shows null in those default fields?
> I have this SQL:
> SELECT  CONTACTS.Company, CONTACTS.Surname, CONTACTS.[First Name], CONTACTS.Counter
> FROM CONTACTS
> ORDER BY CONTACTS.Company, CONTACTS.Surname, CONTACTS.[First Name];
> Default values for the 3 fields are (No prizes!) Company, Surname and First Name.
> The unique identifier is effectively those 3 fields, but 1 or 2 may be default values.  (Counter is not included here!)
> TIA
> Kind regards,
> David

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com