I am trying to filter MS Access DB.

I want bring the data which value is SALES in DB

SELECT *
FROM Client_Registration
WHERE Enquiry_Type = Sales
ORDER BY F_name

But its not working at all. Please help me with advice.

Babu

your SQL query needs to have single quotes around the value that you want to compare like this:

SELECT *
FROM Client_Registration
WHERE Enquiry_Type = 'Sales'
ORDER BY F_name

otherwise, the statement will try to find a field called 'sales' which does not exists in the table, and so will bring up an error message.

Myke.

Edited by - mykeblack on 21 Jul 2005 18:48:38