THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 69: JGJOBBYBLDGTYPE

The query returns a list of Frank Lloyd Wright commissions categorized by primary building material.

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 JGJOBBYBLDGTYPE calls on Table MMTFDRAWINGS FILE with a filter applied on Column [BUILDING TYPE] ("not = blank") to report Frank Lloyd Wright commissions that have been assigned a type of primary building material in the database. The categories of building type can be found as a choice list for Column [BUILDING TYPE]. The report format produced a list showing Frank Lloyd Wright Archives project number, year of commission, client name and project title, grouped by building type with subtotals. The last generation of the report contained 690 entries.

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 69 query image

Report Format

JGDB10 Procedure 69 report form

Document: Dataease Procedure Definition Printout (PDF)