Solved

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

Posted on 2014-09-06
2
859 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now