error No value given for one or more required parameters

[skierm]

i am trying to get "select * from Item where ItemNumber = " & num1 Item is a table and itemnumber is a column. i want to geteverything that has the same item number then take another value from it when i get the info. But, im getting this error No value given for one or more required parameters how can i fix this and is it because ItemNumber is a text field thanks

 

[Rick39]

If ItemNumber is a text datatype, then

"select * from Item where ItemNumber = '" & num1 & "';"

if it is a number datatype then

"select * from Item where ItemNumber = " & num1 & ";"

 

[skierm]

thank you it work great

 

[Rick39]

Glad it helped