Update query - number fields 1

[JimmyRa]

I am trying to do a docmd.runsql to update a database with a few number and date/time fields, from info in VBA variables. I keep getting 'syntax error in statement'

All the text fields work OK, using
" txtfld = '" & txtvar & "'" etc, but what should I do with " numfld = " ???? or " datefld = " ????

Thanks,
JimmyRa

 

[JeffTullin]

"update table set num_field = " & val(txtNumber)


"update table set date_field = #" & format(txtDate,"dd-mm-yyyy") & "#"


should be what you want...?

 

[PHV]

Try something like this:
" txtfld = '" & txtvar & "'"
" numfld = " & numvar
" datefld = #" & datevar & "#"


Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884