I am looking for a break down of how the double quotes work in the following from Allen Brown http://allenbrowne.com/casu-17.html :
If you wanted to look up the city for the CompanyName in your form, you need to close the quote and concatenate that name into the string:
=DLookup("City", "Customers", "CompanyName = """ & [CompanyName] & """")
I'm looking for a explaination of criteria portion and specifically a break down of the usage of quotes.
Here is what I think it is:
The first double quote ahead of CompanyName is needed for this functions criteria section.
Then you have the double double quotes after the equals sign, giving an empty string.
Then you gave a double quote ending the string.
Then at the end, you have a double quote that begins a string
Then a double double quote, giving an empty string.
A finally, a double quote ending the string.
This is probably not right, but can someone break it down like this, and explain it to me.
Thank you.
If you wanted to look up the city for the CompanyName in your form, you need to close the quote and concatenate that name into the string:
=DLookup("City", "Customers", "CompanyName = """ & [CompanyName] & """")
I'm looking for a explaination of criteria portion and specifically a break down of the usage of quotes.
Here is what I think it is:
The first double quote ahead of CompanyName is needed for this functions criteria section.
Then you have the double double quotes after the equals sign, giving an empty string.
Then you gave a double quote ending the string.
Then at the end, you have a double quote that begins a string
Then a double double quote, giving an empty string.
A finally, a double quote ending the string.
This is probably not right, but can someone break it down like this, and explain it to me.
Thank you.