I'm using a continuous form in Access 2007 on my third tag of the form I'm trying to calculate square yards by taking a length fileld multiplying by a width field and dividing by 9 ... first I tried putting this in a query..I got the right results but it appeared to be building a array, which was not what I needed. I need to results to appear in a field on the form. I then tried putting the formula in the control source of an unbound box..where the formula was =(([Utility Permit].[Actual size 1 (lgth)]*[Utility Permit].[Actual size 1 (wdth)])/9) here I kept getting #NAME? in the field instead of the results.
Have I provided enough information to get a solution to my problem?