<div>
Some pseudocode..<br />
<br />

<pre><code id="code-20-39498504-1">select A.SalesValue, B.RevenueValue,
Case when Sum(A,SalesValue) &gt; Sum(B.RevenueValue) Echo B.SalesValue is bigger than A.RevenueValue End
Case when Sum(B,SalesValue) &gt; Sum(A.RevenueValue) Echo B.SalesValue is bigger than A.RevenueValue End
From SomeTable
Left Outer Join A.Emp_id - B.Emp_id</code></pre>
<br />
HTH,<br />
<br />
Kent
</div>


Some pseudocode..



select A.SalesValue, B.RevenueValue,
Case when Sum(A,SalesValue) > Sum(B.RevenueValue) Echo B.SalesValue is bigger than A.RevenueValue End
Case when Sum(B,SalesValue) > Sum(A.RevenueValue) Echo B.SalesValue is bigger than A.RevenueValue End
From SomeTable
Left Outer Join A.Emp_id - B.Emp_id


HTH,

Kent

<div>
Sorry it took me so long. &nbsp;I lost my job and have been in a state of shock. &nbsp;This did resolve the issue. &nbsp;Sandra
</div>


Sorry it took me so long.  I lost my job and have been in a state of shock.  This did resolve the issue.  Sandra

<div>
<div class="content wysiwyg-content">
I have a table in an ACCESS 2010 that is only sample data. &nbsp;However, a user duplicated over 6000 rows but the dollar amounts are different. &nbsp;So, how do I extract only the larger of say, December amounts for duplicate rows of the same forecast year, account number and type. &nbsp;That is, for 2010, AcctNo 14587, BUD that has two rows, but December is 100 for one row and 150 for the second row - I need &nbsp;only get the 150 row.<br />
<br />
Sandra
</div>
</div>


I have a table in an ACCESS 2010 that is only sample data.  However, a user duplicated over 6000 rows but the dollar amounts are different.  So, how do I extract only the larger of say, December amounts for duplicate rows of the same forecast year, account number and type.  That is, for 2010, AcctNo 14587, BUD that has two rows, but December is 100 for one row and 150 for the second row - I need  only get the 150 row.

Sandra

Get larger of two values in a query ACCESS 2010

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.