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