I have an ODBC linked database. Because it is an ODBC link, I am unable to change the properties of the table to supress zero value fields. I need to be able to have my form or table or query suppress the line item when the quantity field is zero. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppress zero value fields
- Thread starter JCridland
- Start date
Databaseguy
MIS
Create a query, drag your field to the grid, and add this to the field criteria:<>0
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question