Sql statement that needs more than one line

[cliff7376]

i posted this in the forms section by mistake as well.sorry. anyways i have a large sql select statement that is longer than one line. everytime i try to bring part of it over to another line by using the _ i get an error. what do i need to use to seperate this statement?please help

 

[jimashton]

I usually split it over a few lines: e.g.

dim sqlstring as string

sqlstring = "the first bit "
sqlstring = sqlstring & "the next bit "
etc.

then pass the sqlstring variable into the openrecordset statement.

 

[Fornatian]

I've just answered it in the forms section!

Please don't post under more than one heading, it is a bit annoying to find you're wasting your time.

Ian