Access Query
 Windows Fix | About Us | Which Computer? | Memory Stick | Copy File | Site Map | 
What is a Browser
 | Search Engine | Windows Explorer 

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"

Previous Page    Next Page    IP


How to fix anything