Help! Write Selection Criteria

  • Thread starter Thread starter news.insightbb.com
  • Start date Start date
N

news.insightbb.com

I have a request to create a Query and not sure how to go about this. This query will look at purchase history of part numbers by a distributor over the course of a year. If the part number was purchased more than 2 times I want to part number to show in the query.

If the part number was only purchased 1 time, not to show. Trying to look for cases of where a distributor has purchased a part multiple times and from that will do an analysis of these specific purchases.

What kind of a statement do I write for the part number field (partno) to select this.

Thanks for your help,
Mike
 
Create a totals query that returns a list of part numbers whose count is
greater than 1 in the table. Store that query.

Then use that query as one of the tables for your primary query. Join it to
the table with the purchase history on the Part number field in both the
table and the query.

--
Ken Snell
<MS ACCESS MVP>

I have a request to create a Query and not sure how to go about this. This
query will look at purchase history of part numbers by a distributor over
the course of a year. If the part number was purchased more than 2 times I
want to part number to show in the query.

If the part number was only purchased 1 time, not to show. Trying to look
for cases of where a distributor has purchased a part multiple times and
from that will do an analysis of these specific purchases.

What kind of a statement do I write for the part number field (partno) to
select this.

Thanks for your help,
Mike
 
Ken,

Thanks very much worked great. I think I was over complicating the
solution.

Thanks again,
MikeB

~~~~~~~~~~~~~~~~~~~~~~~~~
 
Back
Top