The correct expression to create calculated control for (populati.

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

Guest

I am teaching myself Microsoft Access. Working on one of the excercises, I am
being asked to create a calculated control for the population density
(population/area). I'm having trouble in creating the expression. I have
tried to trace back my steps but I'm at a standstill.

Hopefully my message is clear. Thank you
 
I am teaching myself Microsoft Access. Working on one of the excercises, I am
being asked to create a calculated control for the population density
(population/area). I'm having trouble in creating the expression. I have
tried to trace back my steps but I'm at a standstill.

Hopefully my message is clear. Thank you
Click to expand...


None of us can see what you have done or are specifically trying to
do.

To perform a calculation in an Access form you would add an Unbound
Text Control and set it's control source property to whatever the
calculation is.
For example:
=([FieldA] + [FieldB])/[FieldC]

Make sure the name of this control is not the same as the name of any
field used in the expression.

The result should not be stored in any Table.

Now if you need a more specific answer you're going to have to be more
specific in your question.
 
I am teaching myself Microsoft Access. Working on one of the excercises, I
am being asked to create
Which is it? Are you teaching your self or taking a class that ask you to
create?

In the design view grid add another output field like this ---
Population Density: [Population]/[Area]
 
Back
Top