[Select*From StudentResults Where Interaction_Response_ID=12}

[minority2000uk]

I was wondering if you could help i have the bellow code in a querie in microsoft access and this part of the code keep bringing up an error " The microsoft jet databases engine cannot find the input table or query 'select*FROM StudentResults WHERE Intreaction_Response_ID=12' make sure it exsists its name is spelled correctly"

i have checked and it is spelt correctly and exsist so i am not sure what is happening.

[Select*From StudentResults Where Interaction_Response_ID=12}
:?

 

[jrbarnett]

Hi

Put spaces between "Select" and "*" and "*" and "From" so that Access can interpret it correctly, and provided the table and fieldnames are correct, as is the data type (ie for =12 to work, it must be a numeric type field).

John