DLookup Text when using yes/no as criteria (1 Viewer)

murray83

Games Collector
Local time
Today, 21:14
Joined
Mar 31, 2017
Messages
728
Evenin

i have had a look around here for an answer to this and google but i still keep getting #type

code i have tried

Code:
=DLookUp("'[update]'","[T_Version_2]","[current]"=1)

and also with no '

Code:
=DLookUp("[update]","[T_Version_2]","[current]"=1)

i just want to display what was done in this update in a simple little text box. i know its something simple but cant figure it out

is it because im trying to search for number rather then strings

please help

Ta :)
 

isladogs

MVP / VIP
Local time
Today, 21:14
Joined
Jan 14, 2017
Messages
18,186
“Current=True”
“Current=False”


Sent from my iPhone using Tapatalk
 

murray83

Games Collector
Local time
Today, 21:14
Joined
Mar 31, 2017
Messages
728
“Current=True”
“Current=False”


Sent from my iPhone using Tapatalk

like this

Code:
=DLookUp("'[update]'","[T_Version_2]","[current]"=True)

or just get rid of the [ ] brackets and put this

Code:
=DLookUp("'[update]'","[T_Version_2]","current=True")

as with the last one it kinda works as in it no longer screams errors at me but just laughs at me through a blank text box
 

isladogs

MVP / VIP
Local time
Today, 21:14
Joined
Jan 14, 2017
Messages
18,186
Like I did it but also remove the single quotes around “update”


Sent from my iPhone using Tapatalk
 

Users who are viewing this thread

Top Bottom