http://www.programmersheaven.com/ Contains the latest posts from the thread 'Access 2003 and VB6' posted on the 'Visual Basic' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Sat, 25 May 2013 05:27:43 -0700 Sat, 25 May 2013 05:27:43 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/VBasic/427617/427617/access-2003-and-vb6/ We receive a lot of products and perform some tests on these products. We generate report about lot of products. Report has two parts master and detail. Detail contains serial_no of products, quantity and result. Products can have results that are in table RESULTS_MT.<br /> Requirement:<br /> We need to count the TEST_REPORT_NO from table TEST_REPORTS_MT group by TEST_REPORT_DET.Result<br /> There are 10 reports in total in TEST_REPORTS_MT table and count of them is as follows.<br /> Qualified Fail R&amp;D In Process Qualified &amp; Fail Mix<br /> 3 2 2 1 2<br /> <br /> The query should be simple and do not contain UNION as the query will be imported in data environment of VB6 as a view and will be used as data source of report.<br /> My query named ResultSet1 outputs 17 reports whereas total 10 reports are present because it counts some record again. That’s the problem please help.<br /> <br /> <br><br><strong>Attachment:</strong> <a href="http://www.programmersheaven.com/mb/DownloadAttachment.aspx?AttachmentID=2322">Database n Requirements.zip</a> (26413 bytes | downloaded 46 times) http://www.programmersheaven.com/mb/VBasic/427617/427617/access-2003-and-vb6/ Sat, 25 Feb 2012 03:27:17 -0700 Visual Basic