# Identifying bib records with more than one attached item record

**URL:** https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742
**Category:** Sierra, Millennium & Encore
**Created:** [December 4, 2025, 4:41pm UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742 "2025-12-04T16:41:18Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Louise\_Simon](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/l/cdc98d/32.png) [@Louise\_Simon](https://forum.innovativeusers.org/u/Louise_Simon)
#### Post date: [December 4, 2025, 4:41pm UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742/1 "2025-12-04T16:41:18Z")

</div>

Hi

I have a list of bib records and I want to find out how many have more than one item record attached. Is it possible to do that in Create Lists?

Thanks

Louise

---

<div class="post-metadata">

### Author: ![jmgold](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/jmgold/32/228_2.png) [@jmgold](https://forum.innovativeusers.org/u/jmgold)
#### Post date: [December 4, 2025, 7:12pm UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742/2 "2025-12-04T19:12:26Z")

</div>

Not directly but you can work with it. You can run a list of items, export out the bib record numbers and item record numbers (sorted by bib number), and then use excel’s subtotal feature to gather the count of how many times each bib # appears (once per item).

---

<div class="post-metadata">

### Author: ![bgaydos](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/bgaydos/32/1045_2.png) [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)
#### Post date: [December 5, 2025, 1:43am UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742/3 "2025-12-05T01:43:08Z")

</div>

**[Multi-Item Bib Count.sql](https://forum.innovativeusers.org/uploads/short-url/n8XaMDaJkDHetY3kFaY2Etj9z1c.sql)** (856 Bytes) is one way of doing this in SQL.&nbsp; Note that in keeping with Louise’s question, this approach is based on the _contents of a review file of bibs_ and **not** on the bib\_record table as a whole.

[edit] I just realized that any duplicate bibs in the source review file will be counted multiple times, so be sure to use the Dedupe button in Create Lists to clean those up first.

---

<div class="post-metadata">

### Author: ![Lena](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/lena/32/792_2.png) [@Lena](https://forum.innovativeusers.org/u/Lena)
#### Post date: [December 5, 2025, 7:30pm UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742/4 "2025-12-05T19:30:07Z")

</div>

You can do the following:

1. Export bib rec#, item rec# (bib rec and all attached items)

2. Name 3rd column “2nd item”

3. Highlight the header and filter the spreadsheet

4. Uncheck “Select All” in the “2nd item” header and select “Blank” (at the bottom of the filter list)

5. Note the number of records showing in the first column - these have only one attached item

6. Subtract this number from the total number of bib records in your file

I wanted to add a screenshot, but I can’t figure out how to do it on this forum 🤔

---

<div class="post-metadata">

### Author: ![Louise\_Simon](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/l/cdc98d/32.png) [@Louise\_Simon](https://forum.innovativeusers.org/u/Louise_Simon)
#### Post date: [December 10, 2025, 1:55pm UTC](https://forum.innovativeusers.org/t/identifying-bib-records-with-more-than-one-attached-item-record/2742/5 "2025-12-10T13:55:15Z")

</div>

Sorry for the delay. Thanks for all your responses. That’s really useful.
