Search results

Hi Please can anybody help I need to HoursAllowed = 30 Hours for Job: When this field is updated I need all of the rows for that job to sum and if > than [hoursallowed] raise a validation error and rollback to prevous value. What is the best method, I have messed about with a calculated txt...

Hello I am trying to calculate all the values in the group footer. I am using the following as the fields contain nulls. =[Nz]([basildon])+[Nz]([braintree])+[Nz]([brentwood])+[Nz]([Castle point])+[Nz]([Chelmsford])+[Nz]([colchester])+[Nz]([epping])+[Nz]([harlow])+[Nz]([maldon])+[Nz]([outside...

Hello Can any body advise me. I am running a simple sum sum ([SUBTOTAL]/1000) it does not give me the results I am after for example: 8.32 /1000 = 0.0832 - This is the desired result I am getting 8.32/1000 = 0 It does note help if I change the decimal places. What am I missing? Thanks

Hello I was wondering if anyone knows how to do the following; I have the number of years staff have been working for the company which is extracted from the startdate. Based on the number of years service employees are entitiled to extra days leave, so I need to do the following...

Hello I have seen a few example of this but none of them are exactly what I am after. I need to show the road number and not the letter. Eg ZC1000 or A13 Desired result 1000 13 The letters are always at the beginning but there could be 1 or 2 or 3 Any possibilities would be gratefull recieved.