使用Calulated Fields更新表单上的记录（记录已在表中） [英] Update Record on Form with Calulated Fields (Record are Already in Table)

问题描述

亲爱的所有人，我有桌子[TripRecord]有字段（[BowzerNo]类型：文字，[日期]类型：日期），（[柴油]，类型编号，（[现金]，类型编号）， [金额]类型编号）。

Dear All, I Have Table [TripRecord] having Fields ([ BowzerNo] Type: Text, [Date] type: Date), ([Diesel], Type number, ([Cash], Type Number), [Amount] Type Number).

1. 我已将[Bowzer＃]组合框的最后记录称为（[日期]，[柴油]，[现金]，[金额]）值到表格上未绑定的文本框（Diesel1，Cash1，Amount1）。

1.  I Have called Last Record of [Bowzer#] Combo Box to call Values of ([Date], [Diesel], [Cash], [Amount]) values to unbound Text Boxes (Diesel1, Cash1, Amount1) on Form.

2. 我在表格上添加了新的未绑定文本框（Diesel2，Cash2，Amount2）。

2.  I have added new unbound Text Boxes (Diesel2, Cash2, Amount2) on Form.

3. 我已创建新的未绑定文本框以汇总值（TotalDiesel = Diesel1 + Diesel2，TotalCash = Cash1 + Cash2，&TotalConmount = Amount1 + Amount2）。

3.  I have Created new unbound Text Boxes to Sum Values (TotalDiesel = Diesel1 + Diesel2, TotalCash = Cash1 + Cash2,  TotalAmount = Amount1 + Amount2).

4. 现在我想更新我之前从Table [TripRecord]字段（柴油，现金，金额）调用的值。

4.  Now I want to update Values, which I called earlier from Table [TripRecord] Fields (Diesel, Cash, Amount).

请帮助我更新当前更新语句的语法记录。

Kindly help me in regard to correct syntax of Update Statement to update current record.

推荐答案

实际上，我认为"正常化"的第三条规则是是不存储计算值。您应该能够在每次需要时计算该值以确保它始终正确。

Actually, I think the third rule of "normalization" is to not store calculated values. You should be able to calculate the value each time you need it to make sure it is always correct.

只需要我的2美分......

Just my 2 cents...

这篇关于使用Calulated Fields更新表单上的记录（记录已在表中）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！