DYNAMIC STUDENT DATABASE
On Tue, 8 Sep 2009 08:52:02 -0700, Brad Hodges
wrote:
I am an administrator over military courses. I'm trying to slim down an
overly redundant database. I would like to make it as dynamic as possible.
I have two records in the same table; Graduation date and status.
Can I have a graduation date automatically another field called status which
currently is either "active" or "history" without using a manual "update
query" process? I would assuse it's a simple select statement in the status
field but need help.
If the status is "active" up until the graduation date, and "history"
thereafter, then the Status field should *simply not exist* in your table at
all. It can be calculated on the fly in a query:
Status: IIF(NZ([Graduation date], Date()) = Date(), "Active", "History")
--
John W. Vinson [MVP]
|