Convert textbox value to number?

[cplmckenzie]

Hi all,



I have a question and could use some help.

Does the month(function) in Access return a numeric value and how can a value from a
textbox on a form be cnverted to numeric.

Here is a part from My SELECT statement that does return data for the specified month
in txtMonth textbox.

FROM 2014ExpenseList
WHERE [2014ExpenseList].[month(TransDate)] = txtMonth;

What I would like to do is if....
txtMonth contains 12, have data returned for month 11 (November).
Is this possible and how.

cplmckenzie

[pbaldy]

Yes, but the way you're using it Access is going to prompt you, because of the brackets. Try

WHERE month(2014ExpenseList.TransDate) = txtMonth;

Presumably you're actually using the full form reference, since you said it was working.