The SQL is just a sdtriong an manipulation of the string format is
pretty simply. there are some good basic examples in the Access VBA
help. The VBA language is the same in Access as Excel. I have a book
that IU bought put it is not much better than the Access VBA help. The
book has type errors and it doesn't usally work without minor changes.
I get frustrated with the Access code because it usally talks me a
couple of hour s to get it working because the SQL is very particular to
the syntax. It is not clear documented that where you need to put the
VBCRLF and where you need to put commas and semicolons and where it is
optional.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150822

Microsoft Office Help