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

Closed

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,

Skills: Microsoft Access

See more: access guru, price guru, microsoft access guru, code guru, prob, metrics, db query, guru microsoft access, access query table, changes data access, access append, access table query, 2013 query, module create, access create query, course module, hotel table data, crosstab query access, data hotel microsoft access, 186, enhancement access, create hotel, access enhancement, key code, guru access

Project ID: #4311227

20 freelancers are bidding on average $129 for this job

illuminesoft

We have over 13 years experience developing MS Access database projects, over 430 successful projects.

$165 USD in 5 days
(0 Reviews)
7.4
Prashantskin

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

$80 USD in 2 days
(0 Reviews)
6.8
rhomeu

MS Access expert here I can help you with your program

$200 USD in 2 days
(0 Reviews)
6.5
jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$200 USD in 5 days
(0 Reviews)
6.1
Premshanks

Hi, In order to arrive at the metrics - against what it is compared to find the % increase / % decrease etc., It should be easily done and I can work to your satisfaction. Please approve so we can progress More

$75 USD in 5 days
(0 Reviews)
6.0
kulhanekd

I have 15 years exp in access. I can build what you need. Donna

$150 USD in 2 days
(0 Reviews)
5.7
VBAWhizz

HI, I have 20 years experience in Access database design and VBA programming - please see your PMB for further info.

$200 USD in 5 days
(0 Reviews)
4.6
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$150 USD in 5 days
(0 Reviews)
4.6
nutanbhosale

Hi, I can do this project. Please check private message. Thanks-Nutan

$90 USD in 2 days
(0 Reviews)
3.2
MarlinSoftware

Hi, I am a developer with over 22 years experience building complex database systems and could do this project to your specification.

$100 USD in 1 day
(0 Reviews)
3.1
srdas2012

Hi, Please check PMB

$75 USD in 7 days
(0 Reviews)
2.1
anomanpk

I would like to offer my services for this job.

$250 USD in 10 days
(0 Reviews)
1.4
justindonlon

Hi There, I am new to Freelancer, but certainly not new to Access! I've been working with Access and Excel, programming with VBA extensively for over six years and would like to work on your project. I had a look at th More

$100 USD in 5 days
(0 Reviews)
1.1
avenditti70

Hello. I'm an experienced developer with multiple Microsoft certifications (MCP, MCT, MCAD, MCSD, MCDBA). I own a deep experience on .NET development and Microsoft database systems, including Access. I'm also a write More

$50 USD in 3 days
(0 Reviews)
1.0
TBSGADI

Hi, I'm a Senior Access Database and Excel VBA Developer specializing in financial applications. I'm new to this site, but have 20 years experience in developing, maintaining and upgrading applications,many with featu More

$100 USD in 7 days
(0 Reviews)
0.0
BoydMT

I feel fully capable of creating a VBA module that will automate the process of creating the desired output data. My code is very clean, efficient and easily to follow. I have immediate availability, and see no issue More

$150 USD in 1 day
(0 Reviews)
0.0
softdir

Hi There, Please see PM.

$200 USD in 5 days
(0 Reviews)
0.0
bubu77

Hi, Ms Access expert having 8+ years of IT experience. I can do the job for you. Please see your PM for more details.

$45 USD in 3 days
(0 Reviews)
0.0
sudewa

Hi, I can do this project by doing several access queries. I have quoted a very low price since I am looking for my first project. Thanks, Sudewa

$30 USD in 3 days
(0 Reviews)
0.0
dohko1911

Dear Employer, I have understood your requirements and put a summary in separate post to you. Please read and communicate with me.

$55 USD in 2 days
(0 Reviews)
0.0