Advanced Beginner
Windows 7 32bit 
Access 2013 32bit
I have INVOICES table and InvoicePayments table.
In INVOICES table, I have these fields:
InvoiceID, InvoiceNo, InvoiceDate, InvoiceAmount.
Currently I enter InvoiceAmount manually, but now I want to automate the InvoiceAmount field
I can calculate the Invoice Total of any Customer using a Query but I can not put that value to InvoiceAmount field.
Need some help.
VIP
Windows 10 Access 2016
Look at this link on Allen Browne's site. http://allenbrowne.com/casu-14.html
Pay particular attention to the section where he describes why this is a bad idea. Calculations belong in Queries not in tables.
EDIT: This appears to be a duplication of the request you have made in this earlier thread
https://www.accessforums.net/showthread.php?t=68203
Last edited by alansidman; 09-23-2017 at 05:11 AM. Reason: additional post found with same request
Advanced Beginner
Windows 7 32bit Access 2013 32bit
Yes, you are right. Calculated fields must not be saved in tables. Thanks for the guidance.
Moderator
Windows 10 Access 2010 32bit
You may get some insight into table/database design for Customers and Invoices from this material from Barry Williams' site.
Create unique invoice numbers to update a table with records that may or may not have invoices.
Creating invoices and keeping information stored back to a table
Posting Permissions
Reply With Quote