Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    95

    Unanswered: AutoPopulate Field Question

    I have a table with 10 fields. Business name, address, etc. One of the fields is a percentage ranging from 15% through 200%.

    I need one field to autopopulate with the following criteria...

    I need it to display "Yes" if that percentage is >=35%
    I need it to display "No" if that percentage is 15%-34%
    I need it to display "Yes" if there are 5 or more instances of that business

    Does anybody have any instruction on how I need to set this up?

    Thanks,
    CT

  2. #2
    Join Date
    Jun 2009
    Posts
    95
    Nevermind... I do not need this at all.

    Sorry

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Don't you hate when that happens!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •