D
donovan magnefico via AccessMonster.com
hello everyone,
I'm new here and I have a problem with my acces.
the problem is that I've made 5 tables and put a relationship between them.
everything is good.
but I want to make a formula for one of my query's but I'm stuck!!
let's just say... this is de basic formula for one of my query's:
plus/minus hours:= worked hours- ID contract hours.
this formula works good. but the plus/minus hours supposed to be every week.
I want that the formule counts the plus/minus hours just like this:
example: plus minus hours week 1...plus minus hours week 2...plus minus
hours week 3...it have to count it every time.
so if the plus minus hours for this week has calculated it have to count
the plus minus hours for the next week to..en the next week also..etc...
WHO CAN HELP ME, PLEASE?
greetings from Don
I'm new here and I have a problem with my acces.
the problem is that I've made 5 tables and put a relationship between them.
everything is good.
but I want to make a formula for one of my query's but I'm stuck!!
let's just say... this is de basic formula for one of my query's:
plus/minus hours:= worked hours- ID contract hours.
this formula works good. but the plus/minus hours supposed to be every week.
I want that the formule counts the plus/minus hours just like this:
example: plus minus hours week 1...plus minus hours week 2...plus minus
hours week 3...it have to count it every time.
so if the plus minus hours for this week has calculated it have to count
the plus minus hours for the next week to..en the next week also..etc...
WHO CAN HELP ME, PLEASE?
greetings from Don