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/
