?
Solved

Access 2007

Posted on 2013-06-13
2
Medium Priority
?
408 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

765 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