D
David Clasper
Help,
i require assistance on some code. I need to create a calcuate field in a
query depending on the outcome status of a job.
1 each job has a different completed value which is held in a table
2 if the job is No access then the value needs to be shown as 0.1
3 if the job is cancelled then the value is to be 0
this will enable the system to calcuate correctly the operatives bonus.
there are 2 tables in the query.
Table 1 is standing data which contains job types and credits associated to
each job type.
Table 2 is running data ie jobs which the user has attempted. it contains
job type job status date and time etc
the tables are joined in a one to many by the job type. Therefore it needs
to pick up the credit data from Table 1 when working out the job credit if
job is completed but then recalcuating the field to show jobs which were
either no accessed or cancelled.
what i should get is the following results
Job Status credits NewJobCredits
Customer not present, Card Left 0.3
COMPLETED 3 3
Cancelled 0
i require assistance on some code. I need to create a calcuate field in a
query depending on the outcome status of a job.
1 each job has a different completed value which is held in a table
2 if the job is No access then the value needs to be shown as 0.1
3 if the job is cancelled then the value is to be 0
this will enable the system to calcuate correctly the operatives bonus.
there are 2 tables in the query.
Table 1 is standing data which contains job types and credits associated to
each job type.
Table 2 is running data ie jobs which the user has attempted. it contains
job type job status date and time etc
the tables are joined in a one to many by the job type. Therefore it needs
to pick up the credit data from Table 1 when working out the job credit if
job is completed but then recalcuating the field to show jobs which were
either no accessed or cancelled.
what i should get is the following results
Job Status credits NewJobCredits
Customer not present, Card Left 0.3
COMPLETED 3 3
Cancelled 0