By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

different rates for diffrent categories

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The key here is in your statement "....different rates for different works".
You need to build tables to model this statement. But first you need to
analyze exactly what you are saying here. If there multiple works and any
work can have its own rate, albeit a single rate for that work, then you
need to include the rate in your Works table. Such as:
TblWork
WorkID
WorkDesc
Rate
If there are multiple works and any work may have multiple rates, you have a
one-to-many relationship and you need a separate work and rate tables such
as:

TblWork
WorkID
WorkDesc

TblRate
RateID
WorkID
<Something here to distinguish one rate from another for the same work>
Rate
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Zurghew" <An******@avoidspam.please> wrote in message
news:co*********@news-dxb.emirates.net.ae...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.