Microsoft Access AfterUpdate Event
Loading...
Loading...
11,406
Loading...
6:32
Microsoft Access DLOOKUP Functionby 599CD59,358 views- 4:17
Microsoft Access IIF Function (IF/Then)by 599CD59,468 views
- 5:10
Microsoft Access Two Dynamic Combo Boxesby 599CD53,170 views
- 3:18
Microsoft Access Parameter Queriesby 599CD16,116 views
- 12:38
List Box & Combo Box In VB6by akaban019,885 views
- 9:26
Use a Conditional Value in a Calculated Fieldby debissy5,666 views
- 7:53
Databinding Combo Boxby TheMoatMicgi36,820 views
- 4:18
Access - Combining Formsby HugoPhongPresents16,018 views
- 1:45
Access 2007 Make Macro in Form Text Field to open PopUp Form!by hughesling7,688 views
- 5:21
ACCESS-LookUp Fieldsby ProfS02199,383 views
- 2:02
Access VBA Trainingby TCadmin13,379 views
- 6:19
Control MS Access Subform With MS Access Comboboxby sellwindowsmedia9,939 views
- 7:37
Loops and RecordSets in Access VBAby tauyeung7,230 views
- 5:45
Access 2007 Lookup Control (combo box)by OfficeSavant44,520 views
- 1:14
Ms Access Dlookup lesson درس حول دالةby majedshawar5,415 views
- 9:02
Microsoft Access Web Data Synchronization Seminar Previewby 599CD3,707 views
- 9:58
Visual Basic Tutorial: Events & Propertiesby 599CD9,753 views
- 8:42
Access Tip: How to Use Images and OLE Objects in your Databaseby 599CD17,196 views
- 1:17
599CD Microsoft Access Tutorial 101.10by 599CD20,755 views
- 9:58
UI Builder for Microsoft Accessby opengatesw12,307 views
Since ServiceCharge is a calcuated field, I'm wonder why its stored in your database table?
I thought that storing calculated fields or transitive dependencies in a table represents a Third Normal Form violation.
HalifaxHercules 1 year ago
@HalifaxHercules Generally, you are correct. If you can calculate a value in a query, there's usually no reason to store it in a table field. However, there are exceptions. In this video, for example, I wanted to show that you could calculate the value but still give the user the ability to EDIT it, if desired. This way you can say that you're billing the customer for 3 hours at $100/hour, but still manually edit the charge and make it $225 if you want.
599CD 1 year ago
@599CD Also, if you have a situation where you have LOTS of records and BIG reports, you might find that your queries and reports will generate faster if you store values that are calculated, but they're not updated often. For example, inventory levels. Yes, you could calculate the quantity on-hand of a product by SUMming up the transaction tables, but it's much faster for the database overall to update that field when products move in or out and store it in the table.
599CD 1 year ago