Hi Aleesha,

I feel for you as I had to pull exactly that same list a few years ago and realized how many minefields there are-at least how many there are here.  Mostly it has to do with how you define "American" as it turned out that they wanted to include works of silver that might have been designed by a Norwegian if it was made by an American manufacturer.

And do you want to include ceramics that are made in China for the Colonial American market?

And do you include people whose nationality might be Japanese, but whose significant working career was in the U.S.?  They did.

Does "America" mean just the USA?  Or are South, Central, and Canada included?  Do you count native American tribal things?  Do you include Pre-Columbian things?

I could never find a reliable search that could catch everyone in one fell swoop, so ended up doing a whole lot of different searches and creating a massive object package that I added to or subtracted from as I thought made sense of what they were asking for.

I know that doesn't help with your question, but I wish you good luck!

David

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aleesha Ast
Sent: Thursday, December 20, 2012 10:50 AM
To: [log in to unmask]
Subject: Donor constituent report

Hi all,

We've been asked by development for a list of donors of American artwork. So far the best I can do is an advanced query with acquisition-related constituent role (donor), department (American), and object number (I started with 75 for 1975 and after). Is there a report anyone has that can generate a simple list that includes the acquisition-related constituents? What about reports using the constituent module that somehow pulls object-related records within a specific department? I'm trying to think of an easier way instead of printing out these 400+ records. Thanks in advance!

Aleesha Nissen Ast
Assistant Registrar
Norton Museum of Art
West Palm Beach, FL
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.