sql and variables

[Morn]

I am having a problem with an sql statements in my VB.net form.

The DB is access and the sql is as follows:

SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = booking

Booking is a integer variable, I am not to sure if I have entered the variable correctly into the sql.

When I run it it says that there is a missing parameter.

Can anyone see the problem here?

Thanks in advance

Graham

 

[lingsn]

If booking is a variable then it should be something like this

"SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = " & booking

 

[Morn]

That did it!

Thanks