Maybe someone can point me in the right direction.
I have a one-to-many table construct. A problem (Main Table) goes through many states. It can be open, working, closed, etc.
In the many table I have Status and Status Date. What I'm trying to get to show on my Main form is the most current status for any selected problem.
I was looking at the built-in functions for date. I looked in Help, but couldn't find anything that described what each of the built-in functions do. Is there somewhere a collection of this type of information?
Thanks in advance for the help.
jdbegg
Huntsville, AL
I have a one-to-many table construct. A problem (Main Table) goes through many states. It can be open, working, closed, etc.
In the many table I have Status and Status Date. What I'm trying to get to show on my Main form is the most current status for any selected problem.
I was looking at the built-in functions for date. I looked in Help, but couldn't find anything that described what each of the built-in functions do. Is there somewhere a collection of this type of information?
Thanks in advance for the help.
jdbegg
Huntsville, AL