calculation.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm sorry about so stupid question but I can’t understand one thing. So, I crate table (fileds: 1st, 2nd, 3rd) and I crate form (include this 3 fields). Now I need that in form access made some calculation (eg, multiplying), I open properties for that field ([3rd]) and write in formula in control sorce (eg, = [1st] * [2nd]). access calculate amount but this amount that was calculate didn't store into table db in field [3rd]. What I doing wrong and what is corect steps

I have access 2002

All the best and tnx for answers.
 
Your table only needs Field 1 and Field 2. There is no
need to add Field 3 as it can be calculated.

If a field can be calculated from exisiting fields then
there is no need for it to be included in a table.

Remove Field 3 from your table

Create a form using Field 1 and Field 2

Insert a new field on your Form using Field 1 * Field 2

-----Original Message-----
Hi,

I'm sorry about so stupid question but I canâ?Tt
Click to expand...
understand one thing. So, I crate table (fileds: 1st, 2nd,
3rd) and I crate form (include this 3 fields). Now I need
that in form access made some calculation (eg,
multiplying), I open properties for that field ([3rd]) and
write in formula in control sorce (eg, = [1st] * [2nd]).
access calculate amount but this amount that was calculate
didn't store into table db in field [3rd]. What I doing
wrong and what is corect steps.
 
It would be physically possible for you to store a calculated value into a
record by means of an update query. In general, though, it's not considered
to be good practice to store calculated results. Results of intermediate
calculations can be reproduced in expressions used in final results. This
reduces the *.mdb file size, disk storage space, etc. Instead, use an
expression to do calculations in forms and/or reports.
 
Back
Top