DYNAMIC STUDENT DATABASE
John,
Thank you very much. I'm not sure what this creates. I have an admin table
(query) which is derived from an allstudent table. How do I eliminate the
status column yet allow the query to function? What is "NZ" in your example?
Is this a pseudoname? Thanks again.
"John W. Vinson" wrote:
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]
|