Hi, I can use this sql call and find the records I am looking for: SELECT none_ORDER_HIST_LINE.PART, none_ORDER_HIST_LINE.DESCRIPTION, none_ORDER_HIST_LINE.QTY_SHIPPED, none_ORDER_HIST_LINE.DATE_SHIPPED, none_ORDER_HIST_LINE.SHIP_VIA FROM none_ORDER_HIST_LINE WHERE (((none_ORDER_HIST_LINE.DATE_SHIPPED)=#6/29/01#)); What is the parameter setting for #6/29/01# in ZSQL so I can input the date the wish to find? Thanks. Larry McDonnell Proton Energy Systems 50 Inwood Rd. Rocky Hill, CT 06067 (860) 571-6533 ext. 531 Email:lmcdonnell@protonenergy.com www.protonenergy.com