Syntax error (comma) in query expression

[mjd2007]

Hello all. I have an error that has just showed up. The error is as follows:

Microsoft JET Database Engine error '80040e14' 

Syntax error (comma) in query expression 'id = 1,382'. 

/Timesheet/EQ_EditTime.asp, line 26

Here is the query:

SELECT * FROM tblEqMilesHours  WHERE id = " & RecId & "

... and I think that it has something to do with the 'id' being a four digit number. In the database it is set up as an autonumber. What do I need to do to get rid of this error?

Thanks,

Parallon

 

[dhookom]

Do you have the autonumber displaying in a text box? Is there a format set on the text box?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mjd2007]

Thank you for your time. I finally got it by changing the variable from [red]RecId[/red] to [red]cInt(RecId)[/red]

Thanks again,

Parallon