In-table calculation?

[tomslattery]

Hi!

I have a subform going for products returned to the warehouse. Not
unlike one would do in Excel, I want to do a simple calculation that
does the sum of two columns in the table, with the result in 'column
3'. I'm a bit confused as to how Access handles displaying this
information right there in the table:

QtyOrdered + QtyShipped = QtyReceived

Thanks!
~TPS

 

[John Spencer]

Access does not do this in a table.

This would be a calculated field in a query or as the source of a control on a
form or report. General rule is that if it can be calculated and is dependent
on other items in the record, you calculate it to ensure consistency.



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Jeff Boyce]

In rare situations, it is necessary to store such a calculated value in
Access. Generally, not...

If you'll provide more specific description of your situation, folks here
may be able to offer more specific suggestions.

Based solely on a literal interpretation of your field names (e.g.,
"QtyOrdered", ...), you do NOT have one of those rare situations.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.