What is a status field and how can I set one up?

[Guest]

I want to be able to pull dependents over the age of 21 as of April 30 2006.
Then create a form to send to each employee who has a dependent falling into
this category. I would use this information again in 6 months and again send
a form to those employees who require it. This would be an ongoing twice
yearly duty. Any suggestions?

 

[Guest]

What is a status field?
A status field can be a text field identifying the dependent status --
-Full-time student < 23 years old
-Minor
-Major (not a dependent)
The status field can also be a number field with a related table that has
the primary key and text to list all possible statuses. This way you can
only pick from the list until management may approve a new status to be added
to the list.
Additionaly you may use a one-to-many table for the status so as to track
status changes. In this case the relation from dependent to status table
will use the DependentID.

 

[Guest]

Where would I set this up?
I know in a query I could use the criteria line but am unsure in a table.

 

[Guest]

Add a field to the table named Status.

Where would I set this up?
I know in a query I could use the criteria line but am unsure in a table.