Hi Mandy
As I don't see any replies to your query here is one way I've
found. If copy number is not used (we don't use it here) it's not
straightforward but you can create a Bibliographic list first using
whatever criteria needed (if it's on a large section of your database you
might need to do several lists). Once you've got the lists, export
the information into an Excel spreadsheet, outputting, for example: Title
(from the Bibliographic record) and Itemtype (from the Item records
attached to the bib).
In your spreadsheet you then have:
Title(in column A), Itype(in column B and in every following column for
as many items as are attached). In this case, items number 16 (if
there are any) would be in column Q. You could then highlight the
whole spreadsheet, sort it by Column Q and any titles which have a
blank in Column 16 will be at the beginning. You can quickly
move down Column Q until the first entry in it and then delete all those
records above that point and, in theory, you should have a list of all
bibs with more than 15 items.
Maybe someone has a better way but I've not been able to find
one!
At 30/11/2005 09:45, you wrote:
This is a MIME message. If you
are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.
--=__Part0123C2D3.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Morning all,
=20
Does anyone know how to get a list of bibs where there are more than 15
=
items attached?=20
=20
We were advised not to use copy number and I can't think of another way
of =
doing it.=20
=20
TIA,
=20
Mandy
-----------------------------------------------------
This email and any attachments are confidential and intended solely for
the use of the individual to whom it is addressed. Any views or
opinions presented are solely those of the author and do not necessarily
represent those of Edge Hill or associated companies. If you are
not the intended recipient, please contact the sender as soon as possible
and delete it and all copies of it. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this
message if you are not the intended recipient.
The message content of in-coming emails is automatically scanned to
identify Spam and viruses otherwise Edge Hill do not actively monitor
content. However, sometimes it will be necessary for Edge Hill to
access business communications during staff absence.
Edge Hill has taken steps to ensure that this email and any attachments
are virus free. However, it is the responsibility of the recipient
to ensure that it is virus free and no responsibility is accepted by Edge
Hill for any loss or damage arising in any way from its use.
<<<<EdgeHill>>>>
--=__Part0123C2D3.0__=
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
Morning all,
Does anyone know how to get a list of bibs where there are more than =
15=20 items attached?
We were advised not to use copy number and I can't think of another = way
of=20 doing it.
TIA,
Mandy
<p><br>
This email and any attachments are confidential and intended solely for
the use of the individual to whom it is addressed. Any views or
opinions presented are solely those of the author and do not necessarily
represent those of Edge Hill or associated companies. If you are
not the intended recipient, please contact the sender as soon as possible
and delete it and all copies of it. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this
message if you are not the intended recipient.
The message content of in-coming emails is automatically scanned to
identify Spam and viruses otherwise Edge Hill do not actively monitor
content. However, sometimes it will be necessary for Edge Hill to
access business communications during staff absence.
Edge Hill has taken steps to ensure that this email and any attachments
are virus free. However, it is the responsibility of the recipient
to ensure that it is virus free and no responsibility is accepted by Edge
Hill for any loss or damage arising in any way from its use.
</p>
--=__Part0123C2D3.0__=--
Regards
Sheila Smart
Library Systems Co-ordinator
University of St Andrews Library
North Street
ST ANDREWS
Fife KY16 9TR
Tel: 01334 462316