>Hi. Please note that I am a VFP7 user.
>
>Issue: I want a loop that will summarize for each salesman, then do a total for all. My issue is how to format my 'mysm' variable to insert in a sql without error.
>
>Simplified example:
>
>

>IF NOT EOF('query1')
>   mysm ='salesmn' = + ALLT(query1.salesmn) + ' And'
>ELSE
>   mysm = ''
>ENDIF
>

>
>The resulting query expanded:
>

>IF NOT EOF('query1')
>   SELE * from INVOICES where salesmn = 'Randy Waldman'  And  glyear = 11
>ELSE
>   SELE * from INVOICES where glyear = 11
>ENDIF
>

Are you sure there are quotes around the name in the expanded query? You're not putting them there. Try:

mysm ='salesmn = [' + ALLT(query1.salesmn) + '] And'

Tamar