Thanks found the answer on web problem solved. Tony --- In [email protected], "tony_bat" <[EMAIL PROTECTED]> wrote: > > My sql staement looks like this - select mess_id, tape_num, title from > messtbl m, spkr s where s.spkr_id = m.spkr_id and m.dte = '9/18/2002' - > spkr_id is a numerical field in both tables and dte is a date field in > messtbl. > > get error message - data type mismatch in criteria expression. > > any suggestions on what is wrong with statement. > D7 Prof XP SP2 > Tony >
----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/delphi-en/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
