Enter a variable input in a query

[Shootah]

Hi,

I've managed to create this query

test = "Select * FROM table Where fieldvalue = " & value & " ORDER By

This code works just fine if the value returned is a number (for instance 3)

When it returns a text, it gives me the error message 3075 "Syntax error (missing operator) in query expression 'Fieldvalue = value x' " where x is the value chosen in a combobox

Is this a cummon problem?

I'm trying to transport data from an Access datatable towards Excel...

[Shootah]

Found the solution: Needed to put ' " & Value & " ' because it needs 'value' and not just value

[sashi]

Found the solution: Needed to put ' " & Value & " ' because it needs 'value' and not just value

Hi there,

Congrats on your discovery. Take care.