"0" in DLookup

[boblarson]

Welcome. Good luck!

And BTW Bob, I have never used the quote mark and the ampersand in function context like that, and I've never had a problem with my syntax, but I have had a problem with yours. Was it up with that!?.

Adam:

Your way may work but I have never gotten to work on a consistent basis, but I've ALWAYS gotten it to work with the way I showed (If it hasn't worked then something else was not correct, not the using of the concat method).

Just so it's clear, the way I mentioned is the general consensus of the majority of the Access community and here's a couple of sites to begin with (and if you do a search for posts on here and Utter Access you'll see that it comes out almost all of the time and works fine for all involved once they have gotten OTHER issues straightened out):
http://www.mvps.org/access/general/gen0018.htm
http://allenbrowne.com/casu-07.html


that do it the way I mentioned and it is the official MS documented way:

http://support.microsoft.com/kb/208786

There are other factors at work on whether it works or doesn't work as you have to use the correct ' # or blank depending on datatype.

So, anyway, I guess the bottom line is whatever works - works.

 

[ajetrumpet]

Who is AllenBrowne!?

But anyway, I'm actually surprised I've never had used your method. My guess is, I use mine because I have not been trained as a programmer, and therefore don't really think like you guys. If I had to guess, I would say that is it.