You have chosen to sponsor your bid up to a maximum amount of .
Please see document...
I have data in a access table that tracks price changes for a given hotel for future arrival dates. I put the example in a crosstab to make it easier to understand. Row 2 in the arrival date and column A is the Snapshot date or date the data was pulled.
I want an enhancement (prob a module) that will pull the following key metrics from the table by Hotel and arrival date. This code would then append to another table with the following metrics:
Hotel Arrival Date PriceChanges MinRate MaxRate #Price Increases #Price Decreases Avg Price Increase Avg Price Decrease
Hotel XYZ 1/31/2013 3 186 219 1 1 33 33
Hotel XYZ 2/1/2013 3 186 219 1 1 33 33
Will provide DB of course,