look up rejected items

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

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;
 
Back
Top