I am trying to look up the oldest order a member made to update the member table but need a refresher.
Here's what I have:
t: DMin("DeliveryDate","tblTranslationContractHistory","[tblTranslationContractHistory]![ContactID] = [tblTranslationContractMembers]![ContactID] ")
The sql error is can't find the name tblTranslationContractMembers.ContactID
Any ideas to fix my a lib syntax?