Data in the table

[mfuada]

Hi.. i have a question
Could we manipulate data in the table? such as if we do some mathematical operation with the data on the table.. maybe we add or subtract, the data with some value of a textbox in another from.. could we do that??
thx

 

[pbaldy]

Sure; with an update query or recordset, among other ways.

 

[HiTechCoach]

Hi.. i have a question
Could we manipulate data in the table? such as if we do some mathematical operation with the data on the table.. maybe we add or subtract, the data with some value of a textbox in another from.. could we do that??
thx

Sure can. You can do calculation with fields in a query and with controls on forms and reports.

Following the "rules of data normalization", normally calculated values are not stored, but calculated as needed. I find this a great rule to follow after 30+ years of building Accounting Systems.

 

[mfuada]

30+ years? wow.... well until this day i have reach my +14 days on being access programmer... hehehe..
Ok guys i have a another question related to my previous question,
right now i have table with these fields: no; series;maturity_date;and nextdate_coupon_payment;
maturity_date is table to store date of a bonds maturity and nextdate_coupon_payment is a date which is bond's coupon are being paid to the bond holder, usually it's a semiannual, so in one year we paid to the bond holder twice...
Until up to this point i have build a function to calculate the value of the nextdate_coupon payment.. so when i input the new issuance of a bond the input form will input:no,series,maturity_date; and nextdate_coupon_payment
my problem is since the payment of the coupon is semi annual, i don't have a clue to change all my data in the field nextdate_coupon_payment from the the 1st payment date to the 2nd payment date if recent date has already pass the 1st date payment... my intention is to automatically convert the date into 2nd payment date ... should i put the new data in the new table? or is there any suggestion of how i do it?
Thx.......