Hey there, well if the field in the DB is numeric,
for the sake of simplicity lest say it?s an
Integer. A numeric field unlike a text string
should not be surrounded by a single quotes.
For instance, lets say we wanted to return a
recordset of all the people that were named
Bob in a table named names, the SQL would
look like this.
SQL = "SELECT * FROM names WHERE
fldName = ?inputName?.
If on the other hand you were looking for the
customer ID number in a table called names
the SQL would look like this
SQL = "SELECT * FROM names WHERE
fldCustID = " & inputCustID . If the data in the
variable inputCustID is a var type of string it
must be converted to the type of data stored in
the field fldCustID, so if the data stored in the
DB is of the type single, so to must the var
inputCustID. Lets say that fldCustID is an
Integer and the var inputCustID is a string your
SQL can be done like this
SQL = "SELECT * FROM names WHERE
fldCustID = " & Cint(inputCustID).
I really hope that made sense.