Generating the "last work date" to fill in "completion date" field

[rnh]

I'm creating a projects database, and it will have linked sub-tables for "Work Entry" and "Expenses Entry". Each "Work Entry" will have a field of "workdate", which will be entered for every date work is done on the project. I was wondering if I could create an expression such that when a Yes/No field called "Completed" is set to Yes, the date of the last entry for that project's "Workdate" field would be automatically used to fill a "Date Completed" field or perhaps a form or report.



I'm totally new to Access, used a couple other dBase-style programs (including Alpha4) years ago ... I knew how to do something like this with A4, but in playing around for a while and reading quite a few things in help and on the web, I'm darned if I can figure this one out ... any help would be appreciated.

Neil

[June7]

One way is with DMax - a domain aggregate function (DLookup, DSum, DCount, etc).

An expression in query or textbox ControlSource could be something like (assuming ProjectID is a number):

IIf([Completed]=Yes,DMax("Workdate","tablename","ProjectID=" & [ProjectID]),Null)

Access Help has more guidance on domain aggregate functions or Google for info.

[rnh]

Thanks ...

Neil