Calculation in Field

  • Thread starter Thread starter DBaxter
  • Start date Start date
D

DBaxter

Is it possible to have a field do two things? I have
a "CycleLifeRemaining" field that I typically update
weekly with current data. On some items I would like to
have the field automatically calculate my figure so I
don't have to open the calculator, look up
the "CycleLifeNumber" and substract my "CurrentCyclesUsed"
and cut and paste the info. I tried =
LimitedCyclesRemaining Or «Expr» = [Cycle/Life List Table]!
[LimitedCycles] - [Cycle/Life List Table]!
[CurrentCyclesUsed] and when I go to my View form I
have "#Name?" in the field and cannot enter anything.
 
Is it possible to have a field do two things? I have
a "CycleLifeRemaining" field that I typically update
weekly with current data. On some items I would like to
have the field automatically calculate my figure so I
don't have to open the calculator, look up
the "CycleLifeNumber" and substract my "CurrentCyclesUsed"
and cut and paste the info. I tried =
LimitedCyclesRemaining Or «Expr» = [Cycle/Life List Table]!
[LimitedCycles] - [Cycle/Life List Table]!
[CurrentCyclesUsed] and when I go to my View form I
have "#Name?" in the field and cannot enter anything.

Access doesn't support calculations at the table level as it's improper database
design. Calculations belong in your Reports, Forms, and Queries. If you can design
a query that includes your expression then you can just substitute the query for all
places where you are currently using the table.
 
Back
Top