Re: MS access query in mysql

2006-06-15 Thread Andrew Zahn
Thank you very much for the tips and for the links. I think I have it working now with a subquery. cheers, Andrew Zahn Peter Brawley wrote: Andrew Zahn wrote: I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when execu

Re: MS access query in mysql

2006-06-13 Thread Peter Brawley
Andrew Zahn wrote: I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when executed in Access and doesn't work at all in MySQL. I believe it has to Last() and with the # symbols around the date. Any insight into this probl

MS access query in mysql

2006-06-13 Thread Andrew Zahn
I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when executed in Access and doesn't work at all in MySQL. I believe it has to Last() and with the # symbols around the date. Any insight into this problem would be greatly