Solved

Access 2103 Web App: How to create a data macro calculation to update a field

Posted on 2014-09-06
2
891 Views
Last Modified: 2014-09-06
Quick & simple; have to fields and want the third to calculate and then update a third field.  The key if I'm asking right is the 3rd field exists in the table, I just want it "filled in" based on values of the other two fields.

Advice to date is use a data macro.  Could use a little more step by step feedback...
0
Comment
Question by:VirtualKansas
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40307545
Better advice would be to NOT store calculated data, and instead use a query to provide that calculation "on the fly" - something like:

SELECT Field1, Field2, Field1 + Field2 AS [TotalField] FROM YourTable
0
 

Author Closing Comment

by:VirtualKansas
ID: 40307761
Exactly how we do it on desktop.  ...and to add luster to this advice, since we're (all) new to the app. db, we experimented with macros and found our limits in that testing a macro to update the actual field value was inadvertently creating new blank records.

In the interim, to display in the web view we simply created a new control that's source is the two fields for the calculation and disabled it in format.  

The calculation is done in the view and presented in the view in a "read only" field.  Now we get to exercise creating queries in the app. but short term we've got the result for the app. view and seems like the proper method.

What would be super helpful, since we have many views that will benefit from this calculated field, would be to simply copy & paste to the views, vs. having to edit each view once we conquer a little bugger like this one.  For now, thank you for some good validation and reminder of the basics...
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

828 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