Selecting one particular field in the same Access database table?

[Craig]

Is there a way of selecting one particular field in the same Access
database table?
eg. database is -

ID: 1 2
Region: Alsace Alsace
Dept: Bas-Rhin Haut-Rhin

and I just want to use Haut-Rhin placed in a cell on a table ???

Many thanks

Craig.

[Julian Roberts]

Try some SQL like

select * from t where Dept='Haut-Rhin'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Craig]

Hi

Sorry, couldn't get your code to work.
This is what I have so far,
but I can only get it to display the first Dept from the first row of the
Access Table -

SELECT *
FROM AtoZ
WHERE Dept

Any idea's, what it might have to be to get to the second one 'Haut-Rhin'?

Many thanks

Craig.


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d6l4h3$4fo$1@forums.macromedia.com...

> Try some SQL like
>
> select * from t where Dept='Haut-Rhin'
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>