Anyone know the StrSQL Character limitation off the top of your head?

[Julie Alley]

I might be running in to a larger update query statement.

Has anyone else dealt with this? If you have do you recall how you worked
around it?

Thanks,

Julie

 

[kingston via AccessMonster.com]

Build the string in phases:

strSQL = ...

strSQL = strSQL & ...

strSQL = strSQL & ...

 

[Julie Alley]

Cool, I will try that - Thanks Kingston.

Build the string in phases:

strSQL = ...

strSQL = strSQL & ...

strSQL = strSQL & ...