|
|
Posted by Steve on 01/29/08 19:41
"Steve" <no.one@example.com> wrote in message
news:odLnj.1903$nn2.583@newsfe05.lga...
>
> "Ivan Marsh" <annoyed@you.now> wrote in message
> news:pan.2008.01.29.17.52.30.501620@you.now...
>> On Tue, 29 Jan 2008 10:55:42 -0600, Steve wrote:
> but please, demonstrate how my fix 'just died on the vine'.
>
> fyi, oracle:
>
> select *
> from
> (
> select ROWNUM section ,
> <field list>
> from blah
> where state = 'CA'
> )
> where section between x and n
and if you want to add macros to the mix, you can get rid of the temp table
too regardless of access version. create a macro that is called from the
query. that macro simply increments a value per record and returns the new
value as part of the query being run. from there it's just a matter of what?
value between x and n.
but, i'm still waiting on you to prove me wrong. :)
Navigation:
[Reply to this message]
|