look up rejected items

I’m new to access and I’m trying to make a query to look up rejected items.
I’m doing this by date so in the criteria I have “Between [Enter Start Date]
And [Enter End Date]� it is working fine. I need to show items that are
rejected. If there isn’t any rejected we have entered a 0. What do I need
to put in the criteria to show the number of rejected items? Thank you in
advance.

This is a whole lot of guessing on my part as I do not have your data
structure --
SELECT Product, Sum([Rejected]) AS Total_Rejects
FROM YourTable
WHERE YourDateField Between [Enter Start Date] And [Enter End Date]
GROUP BY Product
HAVING Sum([Rejected]) 0;

--
Build a little, test a little.


"Annette" wrote:

I’m new to access and I’m trying to make a query to look up rejected items.
I’m doing this by date so in the criteria I have “Between [Enter Start Date]
And [Enter End Date]� it is working fine. I need to show items that are
rejected. If there isn’t any rejected we have entered a 0. What do I need
to put in the criteria to show the number of rejected items? Thank you in
advance.