Search results

1. To find all products that are Paper in your query all you have to do is right click on the field that is paper and click total, then take out the check from the check box, and then in criteria type yes. This will give you a query for all the products that are paper. You can do the same for...

I will do a search now

ProductNumber ProductName AmtInStock UnitPrice Paper 1489 QQQQQQ 1 $16.95 No 1534 WWWWW 3 $5.99 Yes 2120 AAAAAA 4...

do I have to change the field in my table to 0 and -1? or do I keep it as "Yes" and "No"? Not sure how to do the query for it, I am lost

I try what you said for "Paper" I made another field for Paper but the query return all -1 in that field I want it to return just what I have for "Paper" and the same when I do it for "Metal" I didn't use the " " when I type it in the field am I suppose to?

What would I use for a formuls to find all product that are in stock. like I have a price for all products that i stock, but some i don't have in stock. How would I query for the ones that I have in stock? In my table I have it as UnitsOnHand, I have it as how many, like 1 or 3 or 4 etc. And...

Is there a reason that I can't use spaces? like Product Name instead of ProductName

Thank You I re-did the table as a test, and yes your right i see were my mistakes were. First I was miss spelling, and I was useing brackets. Thank you.. Now I can try the rest of the querys that i want to do. Will post if there are any more questions

I am trying to do a simple querry I am trying to do a querry were I have the product #, product, amount in stock, and the price. All i want to do is get the total amount. I am useing this for a calculation. amount on hand * price. I have this in a new field, the problem is that when I run it, it...