Ado update

[Arthur (AL) Glen]

Hi

>Does anyone know why this code does not work?

> sql = "select chk_no from zzmixer"

Try this

sql = "select " & chk_no & " from zzmixer"

Hope this helps

AL

[Tonny]

what are you trying to do?
sql = "select chk_no from zzmixer" <== this will return check number

sql = "select " & chk_no & " from zzmixer" <== I do not think this will work

is chk_no is a variable being pass or what?




"Arthur (AL) Glen" <alglen2@hotmail.com> wrote:
>
>Hi
>
>>Does anyone know why this code does not work?
>
>> sql = "select chk_no from zzmixer"
>
>Try this
>
>sql = "select " & chk_no & " from zzmixer"
>
>Hope this helps
>
>AL