Solved

Form Values on to a Report

Posted on 2011-02-24
3
272 Views
Last Modified: 2012-05-11
Good monring,

I am sure this has a simple answer but here we go.

I have built a form that has a Field Name: Total. The field name total is the dollar amount from a sub form called items. Inside the Sub form there are additional field names (Description, Qty, Unit, Unit Cost, and Total). First question I have, how could I make this sub form calculate values, Total=(Qty*Unit Price) and store that value inside the Subform.item.total field name AND still use  the footer of the sub form to calculate the total for me. When I do this, it will not let me take the SUM of the total column in my sub form. Any suggestions?

Currently, I have the sub form set up so it takes the total of the user entered values instead of taking the (qty*unit cost) formula into perspective. When I do that, the total shows up correctly inside the main form but the total does not actual get placed as a value inside the table. So when I pull up a report on that specific main form record, no value shows up in the total box of the report. Anyone know how I can make it so that value stays in that record ASWELL as shows up in any report? Any help would be much appreciated.


Thanks!
 Report TotalsTotals.png
0
Comment
Question by:hcp27
[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
3 Comments
 
LVL 40

Expert Comment

by:als315
ID: 34972969
You can get value for field in report from your form.
Select filed in report designer, press Build in data field, select your form and field on it.
0
 
LVL 40

Expert Comment

by:als315
ID: 34972976
"filed" = field
0
 
LVL 19

Accepted Solution

by:
Eric Sherman earned 250 total points
ID: 34973478
hcp27  ...

Always store just the Product ID, Unit Price and Quantity in your Order Details table.  Then calculate the Total or Extended Price (Unit Price x Quantity) when needed for Forms or Reports, etc.

I always use a Query as a Record Source for the Orders table data entry form that includes the Extended Price calculated field as shown below ...

ExtendedPrice: [UnitPrice]*[Quantity]

Then on your form's footer you can  Sum([ExtendedPrice]).  On reports you can pull the ExtendedPrice field as well.


ET
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

752 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