Search for :

Access Query

Now we have a table created we can start to use it

I want to know which customer has the account_no 99999999


The SQL Query would look like this


Select * from Customers
where account_no = 99999999


If the account_no field was not a number but a text field (varchar)
the 99999999 would have to be enclosed in quotes "99999999" you can normally use single or double quotes in any database:-



Select * from Customers
where account_no = "99999999"


    IP