Why would you need to include number of pages in a report?

-needed for physical collections inventory

-number of pages indicates roughly how big the book is

-knowing how thick a book is can be helpful for tracers

Where are page number data fields stored?

-number of pages is in MARC 300, subfield a  

-Subfield A 

-page numbers are also extracted into the instance_physical_descriptions derived table

Warning: Some E-Resources have Page Numbers Listed in Subfield A

This example below shows 236 pages in the item, which is an electronic resources. If your query is only pulling items from a physical location, you should not get any electronic resources. However, it is good to be aware that the physical description may include

It is impossible to account for every variation of page number entry in your query