Hello - I am trying to build a query that displays Prices (along with four or five other columns of static information). The price column is the only column that changes daily, based on an upload of a separate file.
Is there a good way for me to build the query so that the only items that display in the results are the rows that have had a price change from the prior day. In other words, I just need to export a report for prices that change from the prior day (i.e., not all rows).
(I used to do this manually in Excel by having a separate column where I would paste/paste special/values the results from the prior day and then compare the two via a third column that would check for changes in the two columns.)
Is this best accomplished via a 2nd query, or will some other formula in a separate column accomplish this. Thanks for any suggestions!
- Dave