THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 57: JGFLLWBOOKLIBRARY
The query returns a list of books and perodicals, and other materials related to Frank Lloyd Wright found in the library of John Geiger, grouped by type.
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"), [RETAIL] ("not = blank"), and [SUBJECTID] (reads as "P" in the query structure image, below) to group like materials (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, containing 514 entries with a total retail value of $62,977. The comment in the Report Format image below should be consulted.
The query structure is similar to PROCEDURE 134: JGFLLWBOOKS in Database JGDB10; and PROCEDURE 120: JGFLLWBOOKLIBRARY in Database JGDBFULL.
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)