query based on yes/no fields???

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Inherited a database recording incoming goods where each
record, among other things, indicates product in one field
and a yes/no field to designate whether incoming shipments
passed inspection. Need to do a report that shows which
products have passed 5 or more times. Is this possible and
if so how?
 
Jack said:
Inherited a database recording incoming goods where each
record, among other things, indicates product in one field
and a yes/no field to designate whether incoming shipments
passed inspection. Need to do a report that shows which
products have passed 5 or more times. Is this possible and
if so how?
Click to expand...

A query something like:

Select ProductName, Count(ProductName) As ProductCount, Yes/NoField
From MyTable
Group By ProductName, Yes/NoField
Having Count(ProductName)>=5 And Yes/NoField=Yes

ought to give you what you're looking for.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top