<div>
<div class="content wysiwyg-content">
Example table....<br />
<br />
Date,Sales<br />
11-4-2011,$200<br />
11-5-2011,$302<br />
11-6-2011,$448<br />
11-7-2011,$149<br />
<br />
So based on the table above, the query will return the number 2, &nbsp;since the longest streak of sales over $300 was from 11-5 to 11-6.<br />
<br />
I'll take answers in both MSAccess query and C# Linq, but I prefer the MSAccess query.
</div>
</div>


Example table....

Date,Sales
11-4-2011,$200
11-5-2011,$302
11-6-2011,$448
11-7-2011,$149

So based on the table above, the query will return the number 2,  since the longest streak of sales over $300 was from 11-5 to 11-6.

I'll take answers in both MSAccess query and C# Linq, but I prefer the MSAccess query.

MSAccess: Is there a query that will catch a streak? Details...

Example table....

Date,Sales
11-4-2011,$200
11-5-2011,$302
11-6-2011,$448
11-7-2011,$149

So based on the table above, the query will return the number 2,  since the longest streak of sales over $300 was from 11-5 to 11-6.

I&amp;#39;ll take answers in both MSAccess query and C# Linq, but I prefer the MSAccess query.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.