Show data only if price changes

[scorbett]

Good day. I need some assistance. I created a simple table from an excel report I ran from my master database (Not Access). My goal is to show only those parts that have had a price change, either up or down. My table has these columns (ID #, Supplier ID, Order Date, PO Number, Part Number, Unit Price). This is bascially my PO history for a given date range.



I need to create a query (or another table) that will show the entire row data (all for every row) when the price for the part number listed the part number column changes. I'm not sure if that makes sense. My table has 7,932 records. This goes from January to current date. My part numbers will be duplicated, as will dates and purchase orders. I need to see what part numbers have had either price increases or decreases. Any ideas on a simple query or some way I can accomplish using criteria.

Shane

[CJ_London]

perhaps something like

select * from mytable inner join (SELECT partnumber FROM myTable GROUP BY partnumber HAVING min(price)<>max(price)) Q ON myTable.partnumber=q.partnumber