«

I have an Access table with a column of ascending values. I am trying to
find the value in that column that is less than a calculated variable (kind
of like the vlookup function in Excel). Haven't had any success in writing
an sql statement or finding an example. Could someone point me in the right
direction? Thanks Jim

Unfortunately, the code below only selects the first item in my table
instead of the 63rd (which is the first value less than 57.13).
value=57.13
mySql="SELECT * FROM monthly WHERE a_n < '"&value&"'"
Jim

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:...
> sql = "select * from tableName where field < " & yourValue
>
>
> --
> Curt Christianson
> Site & Scripts: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
>
> "Jim Holmes" <> wrote in message
> news:...
> >I have an Access table with a column of ascending values. I am trying to
> > find the value in that column that is less than a calculated variable
> > (kind
> > of like the vlookup function in Excel). Haven't had any success in
> > writing
> > an sql statement or finding an example. Could someone point me in the
> > right
> > direction? Thanks Jim
> >
> >
>
>

I think yo have to eliminate the '

PGei

"Jim Holmes" <> wrote in message
news:...
> Unfortunately, the code below only selects the first item in my table
> instead of the 63rd (which is the first value less than 57.13).
> value=57.13
> mySql="SELECT * FROM monthly WHERE a_n < '"&value&"'"
> Jim
>
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:...
>> sql = "select * from tableName where field < " & yourValue
>>
>>
>> --
>> Curt Christianson
>> Site & Scripts: http://www.Darkfalz.com
>> Blog: http://blog.Darkfalz.com
>>
>>
>> "Jim Holmes" <> wrote in message
>> news:...
>> >I have an Access table with a column of ascending values. I am trying
>> >to
>> > find the value in that column that is less than a calculated variable
>> > (kind
>> > of like the vlookup function in Excel). Haven't had any success in
>> > writing
>> > an sql statement or finding an example. Could someone point me in the
>> > right
>> > direction? Thanks Jim
>> >
>> >
>>
>>
>
>