Re: [IUG] Create Lists Query Help

["Joshua Lambert" <liblamb at gmail dot com>]

I have resorted to exporting all relevant records to MS Access (or
Excel) and then creating the useful queries in it.  Not that this is
an easy or quick fix but it gets me what I want.  You will probably
have to export part of your items at a time and recombine the larger
list later. MS Access can easily handle 450,000 items if you want that
large of a data set. The key is to export clean data that can easily
be imported into either Access or Excel.

I would probably do the same with Steve Casburn's problem he mentions.

If you are interested trying this out respond and say so, otherwise I
won't take the time and bore everyone with unneeded details :-)

Joshua Lambert
Head of Access Services
Missouri State University

On 4/4/07, Sarah Smith <ssmith at saclibrary dot org> wrote:
> I'm trying to make a list of all bibs that do NOT have any SPL branch
> items attached. We are a consortia environment and I made a list of all
> the items that belong to the others and that belong to special SPL
> locations. However, when I generate a list of bibs from those items, it
> is often the case that the bibs have SPL branch items attached as well.
> I did call Innovative and they haven't given me any ideas. I tried
> sorting the bib list by item location (to then weed out the locations I
> want to exclude) but the list grew exponentially in size and maxed out.
> I don't have a million records left in Create Lists to make a really
> large file, so I'm hoping someone out there has a different approach.
> Roughly, I'm dealing with 450,000 items (that belong to partners and
> special locations) and 280,000 bibs (related to those items).
>
>
>
> Thanks,
>
>
>
> Sarah Smith
>
> Systems Supervisor, ssmith at saclibrary dot org
>
> Sacramento Public Library <http://www.saclibrary.org>
>
> 828 I Street, Sacramento, CA 95814
>
> Phone (916) 264-2892; Fax (916) 264-2959
>
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac