D
Don
I have a table with about 125,000 records. The fields consist of Customer
Number, Item Number and Price. Each record indicates a purchase by a
customer. Many of the purchases are for the same item, at the same price;
however, there are occasional price increases. Here is what I want to do. I
want to return every instance of customer purchases when the price is
different. For instance, if customer 1 bought item 2 for $3.00 a total of 10
times and then the price went to $4.00. I want the query to return 1 record
of customer 1 buying item 2 for $3.00 and 1 record of customer 1 buying item
2 for $4.00 (This I can do by selecting Unique Values in the query's
properties. Here's the kicker - I don't want the query to return any items
that have only had 1 price (For instance, 1 unique value) What I'm trying to
do is identify every customer that have had price changes and what they have
been. Any help would be useful if I haven't confused you. Thanks...
Number, Item Number and Price. Each record indicates a purchase by a
customer. Many of the purchases are for the same item, at the same price;
however, there are occasional price increases. Here is what I want to do. I
want to return every instance of customer purchases when the price is
different. For instance, if customer 1 bought item 2 for $3.00 a total of 10
times and then the price went to $4.00. I want the query to return 1 record
of customer 1 buying item 2 for $3.00 and 1 record of customer 1 buying item
2 for $4.00 (This I can do by selecting Unique Values in the query's
properties. Here's the kicker - I don't want the query to return any items
that have only had 1 price (For instance, 1 unique value) What I'm trying to
do is identify every customer that have had price changes and what they have
been. Any help would be useful if I haven't confused you. Thanks...