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
2/1/2006#))
GROUP BY ReturnTbl.ComponentID, ReturnTbl.PartDescription,
ReturnTbl.USL, ReturnTbl.RtnMfgr
HAVING (((Sum(ReturnTbl.Quantity))<>0) AND ((ReturnTbl.USL)=0) AND
((ReturnTbl.RtnMfgr)=0))
ORDER BY ReturnTbl.PartDescription;
Thanks,
Andrew Zahn
--
MySQL General Mailing List
For