Re: Formatting SQL in Access

2003-02-14 Thread Bob Hall
query database On Fri, Feb 14, 2003 at 11:17:22AM +1100, Daniel Kasak wrote: You have to use the visual basic constant: vbCrLf Or vbNewLine. Bob Hall - Before posting, please check: http://www.mysql.com/manual.php (the

Formatting SQL in Access

2003-02-13 Thread Daniel Kasak
Hi all. Hi spam filter. SQL. Query. I'm writing some code in Access 2002 which builds an sql string and then saves it as a pass-through query. I would like to be able to build in some new-line characters or something so that the query is nicely formatted so that when I (or my boss) goes back

Re: Formatting SQL in Access

2003-02-13 Thread Daniel Kasak
Daniel Kasak wrote: Hi all. Hi spam filter. SQL. Query. I'm writing some code in Access 2002 which builds an sql string and then saves it as a pass-through query. I would like to be able to build in some new-line characters or something so that the query is nicely formatted so that when I (or