Access Queries

I have no Idea how to create a query that will show some specific data.
For my coursework, I have to make a query that will show all names who live in a specified area.
Lets say London, and I had to show all the people who live in London.
I have an Address one field, which is stuff like Birmingham, Conrwall, London etc.
Please, It's not like OMG URGENT, but I'd like to know so I can finish this task and move onto the next unit.

Andy, judging from the title of the thread I assume he is using Access and doesn't need to worry about MySQL or PHP.

quote Sullyone

I have no Idea how to create a query that will show some specific data.
For my coursework, I have to make a query that will show all names who live in a specified area.
Lets say London, and I had to show all the people who live in London.
I have an Address one field, which is stuff like Birmingham, Conrwall, London etc.
Please, It's not like OMG URGENT, but I'd like to know so I can finish this task and move onto the next unit.

In your course, are you supposed to be using SQL? If so, there are many tutorials around the Internet for learning SQL. An example of the query you have posited would be

SELECT name FROM Person
WHERE Address = 'London'

Should be fairly straightforward—you're getting the name of all the records in the Person table where the Address is 'London'.

As per my knoeledge i think u should first connect to the database

in java i think we connect like follows


try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:u should specify the dsn name here");
Statement stmt=con.createStatement();
Resultset rs=stmt.excuteQuery("Select * from tablename");
while(rs.next())
{
String data=rs.getString(1);
}

System.out.println(data);
}

catch(Exception ae)
{

System.out.println("Exception arised");
}