DLookup With 2 Criteria - Microsoft Access Forum


	Back to Access Forum Comments List

DLookup With 2 Criteria

Jerry Fowler

4 years ago

I have been trying to get a Dlookup to work with 2 pieces of criteria. The table is named PhoneT and has four fields

PhoneID AutoNumber ( not needed in this example)
MemID ShortText '8 characters mix of AlphaNumeric data
PhoneNo ShortText '10 Numeric characters
PhoneType ShortText 'contains "Work", "Cell" or "Home"

here is what I have tried and keep getting #Error

DLookUp("PhoneNo","PhoneT","MemID =""" & [MemID] & """ AND PhoneType= Home")

DLookUp("PhoneNo","PhoneT","MemID =""" & [MemID] & """ AND PhoneType= Home"""")

and a few more I don't remember at this time. I have rewatched the Concatnation with Double Double quote and the Dlookup TechHelp videos. I'm fine (to a point) before I added the PhoneType but its hit and miss on getting the right phone number.

	Adam Schwanz @Reply 4 years ago
Your second attempt has the right idea, 1 too many though at the end, also missing some before Home ""Home"" Two Double Quotes or 'Home' Single quotes because it's short text PhoneType=""Home"""

	Jerry Fowler OP @Reply 4 years ago
Thanks I had quotes at one point but I'm sure it was just one double quote on each side of Home ("Home") I get confused as I keep thinking that the AND PhoneType=Home would be between their own quotes as its all text. I'll get it at some point lol. Sure appreiceiate the help

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen