[AccessD] SQL Puzzler

Arthur,

Thanks for your help.

To answer your questions... 

1. Is the Attachment-Type list fixed (i.e. nothing unexpected to be found)?

No, the Attachment Type is simply a free-form text field.  However, our users have said that the keywords "Art", "Photo" or "CS" (Customer Service) will be in this field if there are attachments.  




2. Is every Sales Order guaranteed to have at least one Attachment of a
known type?  No.  Many Sales Orders have no attachments.  Other Sales Orders have one or more attachments.  Some Sales Orders have multiple attachments of different types (both "Art" and "Photo" for example).




3. If the answers to 1 and 2 are Yes, would an output something like this
be acceptable:  This Output would work nicely.  




Thanks,
Brad


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Arthur Fuller
Sent: Wed 10/17/2012 9:12 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL Puzzler
 
I think I have a solution, but first I need to confirm or deny a few ground
rules:

1. Is the Attachment-Type list fixed (i.e. nothing unexpected to be found)?
2. Is every Sales Order guaranteed to have at least one Attachment of a
known type?
3. If the answers to 1 and 2 are Yes, would an output something like this
be acceptable:

Sales Order #        Artwork      Photo      Customer-Service
123                               Y                                        Y
234                                                 Y
345                               Y                Y                      Y

Or, if the answer to question 2 is No, then such row might look like this:

456

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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.