NAWCC Information Storage

Back ] Up ] Next ]

Home
Up
 

Model, Name and Jewel Count

This query will allow you to find all runs with a particular model year, text in the Name field, number in the jewel count field and size. The jewel count and size ask for ranges so you can select multiple sizes within the model. You may also leave the name field blank and retrieve all names. Models such as KW18, KW20, etc require an entry in both the model and size fields to select just for a particular KW model. These are not recorded with a model year.

The results reports the starting  and ending  date of each run and the first and last serial number. The jewelling column is the description from the handwritten records, while the gJwl column is the jewel count reported in the printed serial number list (the "gray" book). The Mat'l column is the information on material grade quality from the printed list and the comment column is miscellaneous information from the handwritten ledgers.

Model
Name
minjewels
maxjewels
minsize
Maxsize

 

DateStart DateEnd SerialStart SerialEnd Model Name Size Jeweling jsJewels jsMaterial Comment
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.