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


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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top