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...

How does that work?

Yes, I did remove the total, probably should'nt have but I did'nt think that I needed it at the time. Would the total column in the crosstab be the total for each row? I need the total for the whole group of rows. would it be best for me to put back the total for each row and then use this...

The fields come from a cross tab query and are not table fields. The calculation work fine in the detail part of the report but will not sum in the footer as I dont know the correct syntax.

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...

I now have it working Thanks for suggestions.

If I change the properties in the query grid on the calculation I do not have double tyoe in the list of formats and Currency does not work. Any other suggestions?

Have you tried changing the joins in to the tables in the query?

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

Multiple Case / Iif Hello Thanks for the reply. YEar is just an alias for a date calculation. I have a Start Date - Format(NOW(),yyyy) aliased YEAR I have changed it to SERVICE. So SERVICE is a number of years that the employee has been working for the company. I need to apply the following...

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.