Agent Goal Access Program Project 2

完了済み 投稿 Aug 24, 2008 着払い
完了済み 着払い

Agent Goal Access Program Project

I have created a simple Goal program for sales people. I have created a dialogue box named:

“Dialogue Box Goal Report Office/Agent“ where the user enters the goal report month and Year and Agent number if needed. Then the user can click on a tab labeled:

“Show Agent Monthly Goal Report” or

“Show Office Monthly Goal Report” or

I have already created 2 forms called:

Goals form Agent (these are samples and info is not correct)

Goals form Office (these are samples and info is not correct)

These 2 forms are the way I want the completed form to look. You can use these forms.

(1.) I need someone to correct the dialogue box named:

“Dialogue Box Goal Report Office/Agent“ where the top text box accepts the number 1 thru 12, then the year (07,08,09) and the next text box accepts the agent number.

(2.) Then create a query that when the user clicks “Show Agent Monthly Goal Report”

A. It lists what the agents app goal was for Jan of that year, then calculates actual apps written for Jan of that year, then calculates +/- above there goal.

B. Then lists what the agents premium goal was for Jan of that year, then calculates actual premium written for Jan of that year then calculates +/- above their goal.

C. Then lists what the agents Commissions goal was for Jan of that year, then calculates actual commissions written for Jan of that year then calculates +/- above their goal.

This would need to be done for each month of that year. A query should do the calculations.

Then a total would have to appear at the bottom of the form. The form must look like the one attached to this project named: “Goals Form Agent”

====================================

(3.) Then create a query that when the user clicks “Show Office Monthly Goal Report”

D. It lists what the agents app goal was for that month, then calculates actual apps written for that month, then calculates +/- above there goal for that month.

E. Then lists what the agents premium goal was for that month, then calculates actual premium written for that month then calculates +/- above their goal for that month.

F. Then lists what the agents Commissions goal was for that month, then calculates actual commissions written for that month then calculates +/- above their goal for that month.

This would need to be done for each agent for that month. A query should do the calculations.

Then a total would have to appear at the bottom of the form. The form must look like the one attached to this project named: “Goals Form Office”

=====================================

The basic 2 forms are already set up. Someone needs to change the labels I have created in the samples to text boxes with correct data. Someone needs to create the query/queries

(I would like for this to be done with queries or expressions or whatever with as little code as possible) Thanks

Mike Kuzma

(no code if possible)

プロジェクトID: #305190

プロジェクトについて

3個の提案 リモートプロジェクト アクティブ Aug 25, 2008

アワード:

Prashantskin

Please see the PMB for details and the demo Thanks Prashant

$50 USD 2日以内
(552レビュー)
3.9

3人のフリーランサーが、平均$65 で、この仕事に入札しています。

$100 USD 2日以内
(57件のレビュー)
3.7
proffcomp

Please refer to PMB. Thank You

$45 USD 2日以内
(0件のレビュー)
0.0