Access Guru - Module to create key metrics off of access table/query

Avg Bid (USD)
Project Budget (USD)
$30 - $250

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,

Skills required:
Microsoft Access
Additional Files: Access+Enhancement+Needed.docx
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 165
in 5 days
Hire Prashantskin
$ 80
in 2 days
$ 200
in 2 days
Hire jhaynes75
$ 200
in 5 days
Hire Premshanks
$ 75
in 5 days
Hire kulhanekd
$ 150
in 2 days
$ 200
in 5 days
$ 150
in 5 days
$ 90
in 2 days
$ 100
in 1 days