Code / Syntax Problem (A2K SR1)

[GARYPSWANSON]

The last line of this code causes a syntax error when run. Any ideas why as I have stared at this too long.
<img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

strSql = "SELECT [2002 May].TASK_UID," _
& "[2002 May].CWBS, [2002 May].[Planned Finish]," _
& "[2002 May].[Baseline Finish]," _
& "[2002 May].[Percent Complete] INTO CurrentData" _
& " FROM [2002 May]" _
& "WHERE" _
& "([2002 May].CWBS) Not In (' ','C') AND" _
& "([2002 May].[Percent Complete])<>100 AND" _
& "([2002 May].TASK_IS_CRITICAL)=-1 AND" _
& "([2002 May].TASK_IS_SUMMARY)=No AND" _
& "LEFT([2002 May].CWBS,1) IN ('C');"

[PaulK]

Put a space before "LEFT".

[GARYPSWANSON]

Thanks,

Now that you mention it, I can't figure out why I didn't see this.

<img src=/S/scream.gif border=0 alt=scream width=15 height=15> - that's me when I realized how easy this was to fix..... I will now return to my corner and hide from embarrassment <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

[Devious Dude]

Don't feel so bad. Been there many times. It's called 'can't see the wood for the trees', and the very reason why I use this forum.

[PaulK]

Just FYI I took your code put in a module followed by Debug.Print strSQL and ran it. I was able to find the error by looking at the resulting string in the debug window.

If I had a nickel for every little error I missed I wouldn't be typing into this computer right now <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

[patt]

It's good to see the Big Guns are human too.
Pat <img src=/S/grin.gif border=0 alt=grin width=15 height=15>