Susan,
Sorry about the delay answering - I was having trouble getting onto UT. Have you tried to use two SQLs? Do the first on a single table using the date range, then JOIN the resulting cursor to the other tables for the rest of the data? I've done that several times, and it's often faster than a single SQL with multiple links.
Barbara
>Barbara,
> Thanks for the response. Yes, the datein field is a date field - it's in a 2.6 table though - not yet upgraded to Visual 6.0 structure, but it is a date field. I tried using the between() function, get's 94% through the query and error recurs. I think it's at the same point as using it as is. I can run a query like "sele * from bcdata where datein between m.startdate and m.enddate" and that works A-OK for the same date range - but when I join with the other tables - it bombs.
>
>Susan