F
ffulmer via AccessMonster.com
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 are:
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
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 are:
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