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,
19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
[login to view URL] 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
I am very proficient in MS Access. Queries, Automated Forms and Reports. More so I am extremely good at writing modules that can make your application do anything you can imagine.