dlookup with multiplie criteria one of which is a yes/no (1 Viewer)

murray83

Games Collector
Local time
Today, 12:28
Joined
Mar 31, 2017
Messages
728
Hi merry internet people

i think i may have asked this before but my memory is shocking and cant find what i used it for if i did ask so here i am again

this is my dlookup code

Code:
=DLookUp("[BeenHereText]","[tbl_BeenHere]","[Location]='Stone_Cottage_Basement' AND [BeenHere] = '1''")

what i want the text box to display is Been Here which is stored in the table hence why have 2 criteria one for location and another if true

i have tried True as well as a 1 as shown in the above code but each time i just get the ol #Error

all and any help much appreciated

cheers
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:28
Joined
Oct 29, 2018
Messages
21,357
Hi. Have you tried it this way?
Code:
=DLookUp("[BeenHereText]","[tbl_BeenHere]","[Location]='Stone_Cottage_Basement' AND [BeenHere] = True")
 

murray83

Games Collector
Local time
Today, 12:28
Joined
Mar 31, 2017
Messages
728
Hi. Have you tried it this way?
Code:
=DLookUp("[BeenHereText]","[tbl_BeenHere]","[Location]='Stone_Cottage_Basement' AND [BeenHere] = True")

i hadnt but have now and

You Guys

are the best

it only bloody works :D:D:D

cheers
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:28
Joined
Oct 29, 2018
Messages
21,357
i hadnt but have now and

You Guys

are the best

it only bloody works :D:D:D

cheers
Hi. Congratulations! Glad to hear you got it to work. We're happy to assist. Good luck with your project.
 

Users who are viewing this thread

Top Bottom