M
Mark Olsen
Hi again,
Ok, new question. I need to find information for the last milestone passed.
Now I have a table like this
Main table:
ID | Other stuff ....
Secondary table
ID | MILESTONE | DATE PASSED
1 1 1/20/98
1 2
1 3
The Only indication that a milestone has been passed is if there is a date
in the DATE_PASSED field. So I need a query that displays:
ID | Other info | Last Milestone passed
Now there is a possible that none of the milestones have been passed, in
which case i would just like a NULL field to appear. Any help in doing this
in the query editor or SQL will be awesome. Thanks
Mark
Ok, new question. I need to find information for the last milestone passed.
Now I have a table like this
Main table:
ID | Other stuff ....
Secondary table
ID | MILESTONE | DATE PASSED
1 1 1/20/98
1 2
1 3
The Only indication that a milestone has been passed is if there is a date
in the DATE_PASSED field. So I need a query that displays:
ID | Other info | Last Milestone passed
Now there is a possible that none of the milestones have been passed, in
which case i would just like a NULL field to appear. Any help in doing this
in the query editor or SQL will be awesome. Thanks
Mark