percent

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

Guest

I have a table with 4 fields ...I would like the total to
be 100 depending on certain criteria...sample

Table

OH Land 50 I would like to make sure that total for
OH Forest 30 OH, MI etc would total to 100. Where and
OH Water 20 how would I do this?
MI Land 20
MI Forest 50
MI Water 30


Thanks
 
You'll need to tell us more about how you're entering data and when to
validate the data. Are you using a form to enter data?
 
I would be validating the data in a form. Is there a way
to restrict a user from seeing only one state at a time -
to avoid confusion. Also, could I display the remaining
percent to aid data entry? Can I give the user option for
ALL (land, water, forest,all). But, when the user chooses
this option, restrict him from entering any others (land,
forest etc).

Hope this helps.
 
In general, I believe the answers to your questions would be "yes". However,
setting up the form to do this will take some effort and will involve using
code/macros to verify that the entries are not over 100%, etc.

However, remember that we cannot see your database, so I have no idea about
what you mean in these questions. Let's start with one question at a time
and work through them.

"way to restrict user from seeing only one state at a time" -- do you mean
you want to have user see just one state at a time? How does a user
determine which state should be viewed?
 
I would like to use a drop down list to display the states
and let the user choose. Once a user chooses a state,
only records associated with the state should be visisble
and a user should only be able to add records for that
state only.
 
I think I can see all the records pertaining to one state
only by creating form/subform. But I still haven't
figured out the other questions I have.
 
You can do this with a form and subform setup, or you can just do it on a
single form without a subform. All depends upon where you put the combo box
(for the latter setup, the box goes in the form's Header section).

Are you saying that you've successfully set up the form so that it is
filtering to just the desired state? And that it's using a subform to show
the records for a state?
 
No I have created a form with a drop down list...but, all
the records get displayed...not just the ones for the
selection. What am I doing? I also tried the form/sub
form and it does the same thing.
 
Is the form's recordsource a query that has a criterion expression that uses
the value of the combobox as the value for filtering? And does the
combobox's AfterUpdate event run code that requeries the form's
recordsource?
 
Back
Top