<div>
I think this will work<br />
<br />
Select acct_id from [sometableName] where acct_id &lt;&nbsp;[some value] order by acct_id DESC;<br />
<br />
then just grab the first record returned and that should be the second to last;
</div>


I think this will work

Select acct_id from [sometableName] where acct_id < [some value] order by acct_id DESC;

then just grab the first record returned and that should be the second to last;

<div>
hey guidway....<br />
<br />
Getting close, but can [some value] be obtained using max[acct_id) ?<br />
<br />
steve
</div>


hey guidway....

Getting close, but can [some value] be obtained using max[acct_id) ?

steve

<div>
you could try a subquery<br />
<br />
Select acct_id from [sometableName] where acct_id &lt;&nbsp;(Select max(acct_id) from [sometableName]) order by acct_id DESC
</div>


you could try a subquery

Select acct_id from [sometableName] where acct_id < (Select max(acct_id) from [sometableName]) order by acct_id DESC

<div>
oops you said access... sorry. ;)
</div>


<div>
max function does work in access i believe<br />

</div>


max function does work in access i believe


<div>
thank you for the help...You saved me alot of aggravation<br />
<br />
take care<br />

</div>


thank you for the help...You saved me alot of aggravation

take care


<div>
<div class="content wysiwyg-content">
Greeting <br />
<br />
I cant figure out a query that retrieves only the next to last record where the account number = some value &nbsp;( not the last record inserted into the dbase)<br />
<br />
Im using vb 2005 and access<br />
<br />
Any idea's ?<br />
<br />

</div>
</div>


Greeting 

I cant figure out a query that retrieves only the next to last record where the account number = some value  ( not the last record inserted into the dbase)

Im using vb 2005 and access

Any idea's ?



sql Next to last Record

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,