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,
20 freelancers are bidding on average $129 for this job
Res.Buyer I have gone through your project requirements and the document. I will do the query via module within 2 days only Please see PMB for further details Thanks for your time Regards Prashant