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

Thanks, Randy