boblarson
Smeghead
- Local time
- Today, 02:32
- Joined
- Jan 12, 2001
- Messages
- 32,059
Adam: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!?.
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.