Solved

Help creating a variable/calculation field in a form in Access 2010.

Posted on 2011-03-19
2
161 Views
Last Modified: 2012-05-11
This seems like it would be pretty easy however I don't have much experience in forms.  I'm trying to create a form to display our prices depending on what fields are chosen.  I have 3 tables, Quantity, Stock, and Flavor.  Each table has a key field, a description field, then a number field.  What I'd like to do is display the description field as a combo box for all three tables, then calculate the number fields for those tables off of the description field chosen. So I could display the total amount at the bottom with only showing the description fields as the selectors.
0
Comment
Question by:mds_1
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 35174413
Look at sample Northwind database, which is included in Access.
Could you give tables structure and expected result (in Excel, for example)?
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35176771
"as a combo box for all three tables"  -  maybe a combo box for each of the three tables?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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