I have a table Structure for database: L:\DLYTRANS.DBF
Number of data records: 12787
Date of last update : 09/17/03
Field Field Name Type Width Dec
1 TODAYDT Date 8
2 TIMETRANS Character 8
3 TECHNICIAN Character 7
4 TRANSTYPE Character 10
5 LMCA_NBR Character 7
6 OFFICE Character 10
7 CUST_NAME Character 15
8 NOUN Character 30
9 QTY Numeric 9
10 REMARKS Character 30
11 PRICE Numeric 9 2
12 NBR_616 Character 9
13 QQTY Numeric 9 2
** Total ** 162

SET FILTER To uppe(transtype)='INSP'
brow fiel qty,lmca_nbr
For some reason the QTY field are all 0's!!!!!!!!!!!
if I omit the filt, the qty field looks fine. I've even try a "copy to" but get same results.