Suljettu

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

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,

Taidot: Microsoft Access

Näytä lisää: 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

Tietoa työnantajasta:
( 156 arvostelua ) Saipan, United States

Projektin tunnus: #4311227

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

illuminesoft

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

$165 USD 5 päivässä
(224 arvostelua)
7.3
rhomeu

MS Access expert here I can help you with your program

$200 USD 2 päivässä
(65 arvostelua)
7.0
Prashantskin

[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

$80 USD 2 päivässä
(477 arvostelua)
7.2
jhaynes75

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

$200 USD 5 päivässä
(30 arvostelua)
6.1
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 1 päivässä
(23 arvostelua)
5.5
kulhanekd

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

$150 USD 2 päivässä
(34 arvostelua)
5.8
VBAWhizz

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

$200 USD 5 päivässä
(8 arvostelua)
4.7
winnet21

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

$150 USD 5 päivässä
(16 arvostelua)
5.1
nutanbhosale

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

$90 USD 2 päivässä
(9 arvostelua)
4.7
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 3 päivässä
(8 arvostelua)
3.8
anomanpk

I would like to offer my services for this job.

$250 USD 10 päivässä
(3 arvostelua)
2.6
srdas2012

Hi, Please check PMB

$75 USD 7 päivässä
(2 arvostelua)
2.4
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 3 päivässä
(1 arvostelu)
2.0
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 Lisää

$100 USD 5 päivässä
(1 arvostelu)
1.1
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 Lisää

$150 USD 1 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0
lonniejohnson

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.

$195 USD 3 päivässä
(0 arvostelua)
0.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 Lisää

$100 USD 7 päivässä
(0 arvostelua)
0.0
softdir

Hi There, Please see PM.

$200 USD 5 päivässä
(0 arvostelua)
0.0