One thing you might try is concatenating the two values. As only CHAR
values can be concatenated using the concatenation function, use the CAST
function to convert the DATE and TIME columns to CHAR. Then, use CAST again
to convert the concatenated value to type TIMESTAMP.

  SELECT *
  FROM YourTable
  WHERE CAST(CAST(YourDate AS CHAR(10)) || " " || CAST(YourTime AS
    CHAR(12)) AS TIMESTAMP) BETWEEN "01/01/1999 08:00:00AM" AND
    "06/30/1999 05:00:00PM"

Local SQL (what the BDE uses for dBASE, Paradox, and FoxPro tables) is
documented in the online help file LOCALSQL.HLP, found in the main BDE
directory. This help file is a language reference of the local SQL
implementation (subset) of SQL-92. The copy of this file that came with BDE
4.x (and earlier versions) was outdated and has since been rewritten.
Updated copies will have the topic "Unsupported language" in the index (and
lack of this topic indicates a pre-update copy). I can e-mail you a copy of
the updated file if you need and desire it.

I had been trying exactly what you suggested but I was never able to get
the syntax right.  I cut and pasted yours in and it worked.  I thank you
very much.  After I posted the message I was able to do the same thing with
a whole bunch of ands and ors and a ton of parenthesis.  This will be much
cleaner though.  Thank you again for your help.