Calculate rates

[Zurghew]

Hello all,

I have just created a database (partially) which will bill customers for
work done. However I am stuck when it is comes to different rates for
different works.

REQUIRED: What I intent to have is a form in which I will enter the customer
order no: and then in the subform choose the work done and then based on the
work input calculate the rates and have it billed to the customer. I have no
idea on how to have the rates calculated based on the type of work done and
the number of days.

The fields which will be filled are 'Type Of work' done , also SubCategory
...such as whether ....'new job'; 'edit an old job', 'destroy a job done',
'get help from outside' etc ....for each of these there are different rates.
New job for first day free and later on charged ....similarly editing job
chargable at a single rate for the first day ..then at a particular rate for
the next day.....destroy job done based on the days worked and no of
employees worked at constant rate.....External help done charges. Each
customer bill may also have all of the categories embedded in it.

Bill 100
-------
If work done for CustomerA is new job and for one day then charge A 120$.
Also, work done is Edit job then charge XX based on number of days...etc
Total invoice == Sum of all this.

Please help me out and do let me know if you are having any problems in
understanding.

Regards,
Z

 

[Arvin Meyer]

Try this:

In your TypeOf Work table, add a column for the standard rate. In the
subform, make the type of work a combobox with the Rate as one of the
columns. Use the AfterUpdate event of the combo for some code like this:

Sub cboTypeOfWork_AfterUpdate()
Me.txtExtendedPrice = Me.txtNumberOfDays * Me.cboTypeOfWork.Column(2)
End Sub

Column(2) is the 3rd column in the combo box and the other controls are
self-evident from their names.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access