Built-in Function Description

jdbegg

New member
Local time
Today, 10:15
Joined
Mar 13, 2003
Messages
24
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
 
Do you need to update from this form or not, there are a couple of solutions, I'd just like to be able to steer you in the right direction.
 
I was planning on filling in the Current Status field on the form with status from the Status table and saving it to Current Status in the main table.

It all revolves around the problem I ran in to with subforms. As it stands, I have a Point of Contact subform on the Main form and didn't want to put a second subform on it, so to solve that problem I planned on displaying the current status with a button to open another form which displays the history for the particular Problem.
 
It's been at least five years since I've written any SQL. I remember there was a SQL function where you could retrieve the greatest date.

I seem to remember SELECT Max(Date) from whatever, which would return the greatest date. If this is true, then I'm having a problem interpreting it into the code builder. I don't know if I should go with "Build Event" or place code in Properties. I'm really lost on this one.

Thanks for any help.

jdb
 
jdb,

When working with a status history this is what I have done.

Your main form has a status field. When the status is
promoted/demoted use the Before or After Update event to
log an entry into your status history table.

When you view this table from your form, either as a subform or
as a popup, use SQL's Order by Descending to put the most
at the top.

Wayne
 

Users who are viewing this thread

Back
Top Bottom