If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
look up rejected items
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. |
Thread Tools | |
Display Modes | |
|
|