Hello,
I would like to ask advice on database / query design.

I intend to create a salary calculator in Access 2007.
In my plan there are different job positions and different salary categories
for each
job positions.

For example job positions:
boss
assistant
worker

And there are salary categories:
Normal
Saturday
Sunday
48hours

Then I could combine different job positions with different salary categories.


My tables a

tbl_jobpositions
jobpositionsID
basicsalary

tbl_salarycategories
salarycategoriesID
salarycategory

tbl_salaries
salariesID
jobpositionsID
salarycategoriesID

I created a query that calculates all the salary possibilities for each job
position.
The first field is coming from a table field the rest are calculated fields.

Jobpositions Normal Saturday Sunday …………..
Boss calculated calculated calculated
Assistant calculated calculated calculated
Worker calculated calculated calculated

And at this point I am stuck. I don’t know how to retrieve the calculated
data from the query,
how to look up a data from the query according to the tbl_salaries table.
I can use criteria to show records in the query but I don’t know how select
fields in the query.

Or maybe I am going in a wrong direction? Any one can give me advice?

Thanks in advance

ffulmer

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1