Home

Generating an expiry date based on fields in different tables.

%3CLINGO-SUB%20id%3D%22lingo-sub-1018864%22%20slang%3D%22en-US%22%3EGenerating%20an%20expiry%20date%20based%20on%20fields%20in%20different%20tables.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1018864%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20a%20field%20that%20gives%20the%20date%20a%20certificate%20expires.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20i%20would%20create%20a%20query%20and%20add%20a%20field%20using%20something%20like%20this..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edateadd(%22d%22%2C%20%5BDaysToExpire%5D%2C%20%5BDateStarted%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20trouble%20is%2C%20%5BDaysToExpire%5D%20is%20on%20a%20different%20table%20to%20%5BDateStarted%5D.%20how%20do%20i%20resolve%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20get%20the%20query%20field%20to%20refer%20to%20both%20tables%3F%3C%2FP%3E%3CP%3ECan%20I%20create%20a%20lookup%20field%20on%20one%20of%20the%20tables%20that%20auto%20populates%20once%20the%202%20tables%20a%20linked%20by%20a%20record%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20all%20pretty%20new%20to%20this%20so%20sorry%20if%20my%20language%20is%20a%20bit%20off.%20Any%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1018864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edateadd%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
User2428
New Contributor

I want a field that gives the date a certificate expires.

 

 

I think i would create a query and add a field using something like this..

 

dateadd("d", [DaysToExpire], [DateCompleted])

 

My trouble is, [DaysToExpire] is on a different table to [DateCompleted]. how do i resolve that?

 

Is there a way to get the query field to refer to both tables?

Can I create a lookup field on one of the tables that auto populates once the 2 tables a linked by a record?

 

I am all pretty new to this so sorry if my language is a bit off. Any help would be much appreciated.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies