DLookup

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

DLookup

Post by burrina »

Code: Select all

If DLookup("[FullBackup]", "SetBackup") = Date And [RunOnce] = False Then
I need to lookup FullBackup and also RunOnce from Setbackup
RunOnce is a Yes/No field and and FullBackup is a Date.
FullBackup part works but not when I add RunOnce

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: DLookup

Post by HansV »

Perhaps

Code: Select all

If DLookup("FullBackup", "SetBackup") = Date And DLookup("RunOnce", "SetBackup") = False Then
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: DLookup

Post by burrina »

Thank you Hans. Always get confused with multiple criteria.