THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
PROCEDURE 120: JGFLLWBOOKLIBRARY
The query returns a list of books, perodicals, and other materials related to Frank Lloyd Wright, grouped by type, found in the library of John Geiger.
Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.
PROCEDURE NOTES
Procedure JGFLLWBOOKLIBRARY on Table MMJGBKLB with filters applied on Columns [SUBJECT] ("Wright, Frank Lloyd, 1867-1959") and [RETAIL] ("not = blank") to group like materials (Audio/Video, Book, Manuscript, Periodical, Catalog/Brochure, Frank Lloyd Wright Foundation publications ["FLLWFounPublicat"], and Miscellaneous Frank Lloyd Wright items ["Misc. FLLW", for letters and architectural drawings]). The report format produced a list showing an inventory number, author or editor, the title of the publication, and retail value. The last generation of the report contained 403 entries, with a total retail value of $45,714.
The query structure is similar to PROCEDURE 57: JGFLLWBOOKLIBRARY, PROCEDURE 134: JGFLLWBOOKS, and PROCEDURE 149: JGBOOKLIBRARYFLLWON1 in Database JGDB10; and is somewhat similar to PROCEDURE 65: JGFLLWBOOKLIBFORMVW in Database JGDB10. Report formats differ.
Database Search
Search based on this procedure cannot be executed through the version of the database available on the website.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)