peskywinnets
Registered User.
- Local time
- Today, 11:32
- Joined
- Feb 4, 2014
- Messages
- 576
if I have two criteria for a dlookup...one being text & the other a number ...bot stored in variable what would the command be?
So for example, two variables....
search_name = "john"
search_age = 49
I wish to use those variables above to search a table called members for a surname using dlookup...
dlookup("surname","members", name= search_name AND age = search_age )
it's the syntax in red I can't get right ...any ideas?
So for example, two variables....
search_name = "john"
search_age = 49
I wish to use those variables above to search a table called members for a surname using dlookup...
dlookup("surname","members", name= search_name AND age = search_age )
it's the syntax in red I can't get right ...any ideas?