>Try to change WHERE clause to
WHERE BETWEEN(ARSTrans.DateShip,CTOD('2005/01/01'),DATE()) OR ARSTrans.DateShip IS NULL) ;
>
>
>>Tried the following query in VFP9, VFP8, and VFP7. Records returned were 226, 236, and 232 respectively. I was expecting 263 because that is the number of records in the table on the left, RoseBran. Can anyone see what I'm missing here?
>>
As to the missing record, it turns out I had a duplicated record in RoseBran.
Thanks again,
Jim