Search results

Can anyone help at all,,, please.

Hi all, i am trying to get the above code to work. I have placed it in the on load event of my form and put in a date of 17/12/2010 for testing purposes. However i cannot for the life of me get it to work.

Hi Dave, I am trying missinglinq advise.

I am using =Nz([GrossOperatingProfit],0)/2 in the control source.

Thanks for helping, i have tried what you suggested, i have placed the calculation in my gross operating profit after update and removed the calculation from the control source but the figure just shows zero, i cannot get it to work out the value??

Sorry Dave, sometimes the amount may be slightly different but only on a few occasions so i was hoping that maybe i could edit it.

I have a calculated field, with a control source of =Nz([GrossOperatingProfit],0)/2 i am hoping that if i have a yes/no tick box and i select yes that i will be able to manually change the figure in the calculated field. Is there a way i could do this?

Hi everyone i worked it out in the end so thankyou for all your help. Maybe you could help with another query i have? I have another calculated field, with a control source of =Nz([GrossOperatingProfit],0)/2 i am now hoping that if i have a yes/no tick box and i select yes that i will be able to...

Hi, The calculation i have in my field is =Nz([GrossOperatingProfit],0)/36*5 Many thanks for your help

I have a field that has a formula attached that will work out commission based on other fields, the total is then displayed in that box. On occasions that figure will not be due so i would like to have a box of tick box that i could select which will set the figure to 0. As there is a...

Hi everyone, I have a formula which works out commission based on various other fields. On occasions i wont want it to be worked out and will want it to be zero but on others i will require it to be worked out. If i place a tick box next to the commission field saying paid yes/no, if i...

MStef I have done it, thank you so much for all your help and patience.

Hi MStef I have opened your Form2 and that is exactly what i want however i cannot work out how you have achieved this. I would prefer not to use a Query.

Hello, it was set to continuous but all the other fields do not duplicate across them all but that one field does?

Thanks for all your help everyone i now have it working with one slight problem. My form is a tabular so the end value is duplicating on all records which i dont want???

Hi John, I have tried what you advised in post number 3 but my "AmountDue" field displays #Name? and doesnt work it out, i am placing the code in the control source of the AmountDue field.

Hi All, I still cannot get this to work :-( if i explain by example: I have on my form 3 fields all next to each other, one is called "call spend" then "percentage" then "amount due" If i enter £2850 in to call spend and 10% in to percentage i want it to work out the 10% of £2850 which will...

The problem is i want it to work out the percentage back value and place in the total box but am unsure as to the formula as the percentage will always differ.

Hi Everyone, I am adding a new form to my database which will have a field called "percentage back" there will also be a field called "monthly costs" once a figure has been entered into the field "monthly costs" i would like it to work out the percentage figure and put that into a "total...

Hi all, Please help all you can. I already have a split database, the back end on a server and front end on two computers. I want to copy the database so i can amend it for our other company. I have copied the front end and back end to a new location so im guessing i need to relink, then make...