Search results

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?

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]

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

hi I have a report that should show details of a job such as, customer details, start dates and materials ect. when i open a report for a job that does not have any materials added to it yet it opens up blank. Is there a reson for this and is there a solution? Thanks

hi I have made a database and done test on it to make sure everything works correctly. is there a way to get the auto number to return to zero, for when real data is added? thanks.

I have made a database and am wondering if it is possable to import a word document?

Hi, I am writing some code for a database button but the error message argument not optional appears, saying that my OpenForm is incorrect. The code is below can any body help? Thanks. Private Sub Command47_Click() DoCmd.OpenForm.[tbljobs main] DoCmd.GoToRecord , , acNewRec DoCmd.ApplyFilter...