Thanks John -

I know the feeling - I want to blame mine on 'occupational hazards', but it's probably in the genes :)

Sylvia

>I'd forget my own head if it wasn't attached....here is the corrected code:
>
>

>SELECT ev_eventdesc,ol_quantity,ol_orderno,pe_firstna,pe_middlei,pe_lastnam ;
>   FROM cfevents ;
>      LEFT JOIN cforder1 ON cfevents.ev_code=cforder1.ol_evcode ;
>      LEFT JOIN cforderh ON cfevents.ol_orderno=cforderh.oh_orderno ;
>      LEFT JOIN cfpeople ON cforderh.oh_peoplid=cfpeople.pe_peoplid ;
>   WHERE SUBSTR(cfevents.ev_code,1,4) = ALLT(STR(YEAR(DATE()))
>

>
>I had forgotten your filter.