Solved

Access 2007

Posted on 2013-06-13
2
393 Views
Last Modified: 2013-06-13
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?
0
Comment
Question by:EASCOA
2 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 39245861
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
 

Author Closing Comment

by:EASCOA
ID: 39245997
Is "recordsource" the same as "control source"?  If that is I tried that and I get the #NAME? error.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question