Dimitris Afendras Dimitris Afendras - 2 months ago 12
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

Answer

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

SELECT *
FROM yourTable
WHERE quantity > 0