Access 2007

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?
EASCOAAsked:
Who is Participating?
 
pdebaetsCommented:
Once you have the calculated field in your query, just use the query as the recordsource for your continuous form, then put the calculated field on the form as you would any other field from your table or query.
0
 
EASCOAAuthor Commented:
Is "recordsource" the same as "control source"?  If that is I tried that and I get the #NAME? error.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.