Access Guru - Module to create key metrics off of access table/query
This project received 21 bids from talented freelancers with an average bid price of $127 USD.Get free quotes for a project like this
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,
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online