Search for Same Criteria Multiple times

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pcarperutk@gmail.com - 31 May 2006 00:42 GMT

I'm making a Cut list for a Department for materials based off a
Product ID. When I enter all my Product ID numbers into the Criteria I
want the materials for, if I have 2 Product ID's....Access groups them
into one ID when I run the Query.

Ex:
Field: Product ID
Table: Product
Total: Group By
Sort: Ascending
Criteria: 5 OR 6 OR 12 OR 12 OR 7

I get the parts I need for 5, 6, 7, and 12 but only parts for one 12.
How would I write an expression to receive duplicates without having to
change all my relationships and primary keys?

Reply to this Message

KARL DEWEY - 31 May 2006 01:45 GMT

It has nothing to do with relationships and primary keys.
You are using a totals query and so it rolls everything that is alike
together. Change the query to a select query.

> I'm making a Cut list for a Department for materials based off a
> Product ID. When I enter all my Product ID numbers into the Criteria I
[quoted text clipped - 11 lines]
> How would I write an expression to receive duplicates without having to
> change all my relationships and primary keys?

Reply to this Message

John Spencer - 31 May 2006 12:59 GMT

The database uses the criteria to identify which records to return. It
doesn't use criteria to decide how many of each record to return.

If you say I want all records with 12 and then you repeat that statement (I
want all records with 12), you are going to get all records with 12 but only
once.

To do what you want you would need some method of specifying the number of
twelves you wanted. And by default the number of fives, sixes, and sevens.
A pretty problem that I don't see the solution for. I'm sure it can be
done, but it would probably involve adding an additional table or fields to
an existing table - depending on your table structure.

Reply to this Message