End-user's input to categorize records

I

IntrepidGT

How do I get data that an end-user entered in a form to catorgize a certain
record?
Example: Sponsors for an event are divided upon how much they give for that
event. A sponsor of an event pledges $500. The end-user enters $500 into a
Textbox on a form. A field in the sponsor's record is thus changed to a
particular level.
I'm thinking this is an issue solved by a query, but I've been told that
"If/then" criteria is a programming issue. I would really like to know how to
accomplish this.
 
L

Larry Linson

If the information to determine the category is held in the record itself,
then it would be redundant to include a field for the category (which is a
"calculated field") -- simply calculate the category in the query when you
use the records.

Larry Linson
Microsoft Access MVP
 
Top