>>>>Hi Tore
>>>>
>>>>Nice to see other than me online.
>>>>
>>>>Are you any good at SQL? cos I sent this message yesterday and I can't figure why my SQL was working fine but now just selects all, or many, operators
>>>>
>>>>Message #1141384
>>>>
>>>>I'd really appreciate any help, and I'm going round lately cap-in-hand, as I need to get this finished before tommorow of I don;'t go on holiday (all booked)
>>>>
>>>>Cheers
>>>>
>>>>Terry
>>>
>>>Is this "real" SQL or VFP SQL? If it's "real" SLQ, I have to pass, since I only have experience with VFP SQL.
>>
>>No VFP (7) SQL :-)
>
>Well, at least I see that the Between syntax in the Where clause is incorrect:

>And (ET.date BETWEEN ldStartCurr and ldEndCurr ;
>  OR ET.date BETWEEN ldStartPrev and ldEndPrev)

No, this is legal VFP SQL Between, as opposed to the VFP BETWEEN() function. This is not the problem. The dates are never null AFAIK :-)

>Should be something like

> And (between(ET.date,ldStartCurr,ldEndCurr) ;
>  OR between(ET.date,ldStartPrev,ldEndPrev))

>What happens if ET.date is empty or NULL?