Ms access select statement not retrieving-CodePudding

i have a select statement below, but its not correctly retrieving what i want and throwing an error, help am new to ms access

SELECT order_id, ord_amount, order_date, ord_num FROM orders WHERE agent_code=B5458

CodePudding user response：

Your code is text, so:

SELECT order_id, ord_amount, order_date, ord_num FROM orders WHERE agent_code='B5458'

CodePudding user response：

Looking at your query, the error message is due to you not ending the select statement with ; also the where condition should have ''

so your query should look like this SELECT order_id, ord_amount, order_date, ord_num FROM orders WHERE agent_code='B5458';

try it, it should work