Dimitris Afendras Dimitris Afendras - 1 year ago 80
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 Source

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

FROM yourTable
WHERE quantity > 0
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download