Recent content by dawson321

Thanks its sorted now

How would I put the NZ() in as this is the calculation I have at the moment. Nz(=Sum([Material Charges]))

hi, i have a calculated feild on a report to add up material totals, but there are not always materials to add up. I am wondering if it is possable to give this feild a default value of 0, as i am unable to figure out how to do it myself. is it possable? if yes how can it be done?

Thanks bob its workin now

This is what i have in at the momment but its still not working =IIf([charges]>0,[Total labour charge],[charges]+[Total labour charge])

hi, I cant get this if statment to work and i am nt sure what i am doing wrong. can someone help? =IF([Material Charges]>0=[Total Labour Charge], IF [Material Charges]<0 [Material Charges] + [Total labour charge]

G37Sam are you going to have a look at the database that i have uploaded?

y shoudent i

this is the database in a zip folder its on the job details form.

i have surrounded the names but the code is still is not working. Do you know another way?

That not workin this is what have got in me!Total labour charge = me!labour charge per day * me!How many days labour

i am mutilping a labour cost by the number of days worked but i want to figure to be saved so it is shown in the report.

Do you mean in the table?

hi, I am wondering if it is possable to copy data from feild to another automaticlly. This is becuase i have a caculated feild and a feild with a control source linked to a table. What i want to do is copy the number in the caculated feild to the one with the control source in it so that the...

hi, I am wondering if it is possable to create a marco or query that will seach a table for blank feilds under a spesific heading, (such as "date paid in full"), and then bring the entire record up in a report. Is it possable? if yes how can it be done? thanks