>or why don't you make a where clause which covers the complete data range eg where datetime > 1/1/1900 or something.
>
>I'm not a VFP expert, so I don't know if that is making sense here.
Because he also wants the option of returning data for a single date. With the between function, you can return data for a single date or a date range.
Mark McCasland
Midlothian, TX USA