Remove data if field value is zero

[tombarberio]

Good afternoon. Please be patient as I am a first time poster.
I have an inventory Datasheet.
The following headers are present. Name Part Shelf Stock
I would like to build a Query, Report, Table, (pretty much anything) that will take my entire Datasheet and remove
any Horizontal row that has a 0 (zero) in BOTH Shelf and Stock on the same Horizontal line.

Name Part Shelf Stock
Tom 001 1 0
JoAnn 002 0 1
Ed 003 0 0

If this was my Datasheet, this is what I would like returned upon running this Query, Report, Table:
Name Part Shelf Stock
Tom 001 1 0
JoAnn 002 0 1

I would like the main Datasheet to remain intact, only the Query would have the omitted information.
Please, please, advise.


T.B.

[ssanfu]

Welcome to the forum.

First, "Name" is a reserved word in Access and shouldn't be used as object names.
http://www.allenbrowne.com/AppIssueBadWord.html

You can create a query that will filter (omit) records.
Try this (air code)

SELECT [Name], Part, Shelf, Stock FROM YourTableName WHERE Shelf > 0 AND Stock > 0;

Replace "YourTableName" with the actual table name.

[tombarberio]

I appreciate your quick response and it seem like it may work, HOWEVER, I have no idea what to do with the information you have provided...if you or someone else out there could take the time to explain how to implement the above advice that would really be a big help.

[June7]

Use the query builder. Steve has given you the syntax for a query that can be constructed with the Access query builder. Switch the builder to SQL View to see the SQL statement. You can even copy/paste the statement given and just type in the correct table name then switch back to design view.

Using the query builder is basic Access functionality. Access Help will have more guidelines.

[tombarberio]

Okay, got it. Now the example I used had much less data than my actual Datasheet. So now my question is how can I easily take all of my Headings and move them into the SQL View? Is there a way to copy/paste? There are approx 20 heading which I would have to use. Thank you all again!

[June7]

Not sure what you mean by 'move'. In query design view select whatever fields you want on the Field row of the design grid.

[tombarberio]

Awesome! Resolved! Thanks again!!!