Dimitris Afendras Dimitris Afendras - 5 months ago 35
SQL Question

Whats the query that filters a table, in order to display only a portion of the results in ms access

I have a table with many entrys but i only want to display the items with quantity over 0. What a query like that would be like? and how do i use it? Complete noob in Access and VBA


Going by just what you said, you can try the following query:

FROM yourTable
WHERE quantity > 0