Access help

[Nocturnal]

I?m trying to create a db in Access. Basically at work I get paid commission on each job I do. So, I?d like to keep track of it using an Access database. I took a class this past semester and I sorta have a grasp on using Access.

However, I have a problem. So far my tables will consist of a Job table which will include the type of job such as Premium or Advance and a ClientTable which will contain information pertaining to the customer. The thing is, should I create another table to place the JobPrice because Premium is a static amount and it never changes. Or should I add it to the Job table? Then, I need to calculate my commission, I get x amount per job, so I would need something that calculated Premium * commission.

How would I go about doing this?

 

[Drako357]

Is it possible that your Job price could change, because it it could you might be better of creating a table that links to the Job table by a common ID and use a unique id that tracks your rate for that specific job and also the clientID.

 

[EagleKeeper]

As Drako stated above, have a field in the Job table that links to a price.
If it is possible that the commission changes, then also create a similar field/link to the commission rate table.

Then you can easily pick up different rates for the job and commissions without affecting previous data as would happen in the price/commission rates were fixed in stone for you.

When a report/query is generated, that final price can be displayed by showing the price and commission calculations.

 

[Nocturnal]

Hey thanks to both of you guys that is awesome and a great idea. I will try both and I will report back on my progress. Thank you again.