write a simple query in access 2003?

[ComputerGuy2006]

I am working with an old legacy DB in access (yuck).

And I am wondering if there is a simple way I can query these tables?

Like 'select firstName, count(firstName) from people group by firstName'

 

[VtPC83]

Yes, you should be able to do that. I don't recall how but I believe it a function of Access in general.

 

[ComputerGuy2006]

yeah, but I was not able to find any spot to submit any queries

 

[KB]

Its pretty easy. You just need to open the database in Access and create a new query. See

http://inpics.net/tutorials/access2003/basics39.html

 

[ComputerGuy2006]

Thanks, but I had tried that, and I dont have either of those options when I click on query...

I gave up on trying to get this to work in access, apparently submitting a simple query in access software is too complicated... GJ Microsoft....

I ended up just using PHP using a PDO to connect with odbc.

 

[cabri]

Access has a query wizard that you can use as a starting point.

From there; you can edit the SQL code from within Access