[AccessD] SQL Challenge!!!

Tortise@Paradise tortise at paradise.net.nz
Sat Aug 23 03:22:18 CDT 2003


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
_________________________________________________________________________
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.




More information about the AccessD mailing list