Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
21
Project Description

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,
thanks,

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online