Selecting a "field" not in a table - possible? 1

[AndrewWolford]

I have what I hope to be an easy question, but I can't seem to figure it out.

For simplicity, I'll use a basic example. I have a table that I'm selecting fields from (name & address). I want to create a field (city) populated with "Seattle" to display in my query results, but "city" is not in the table I'm pulling from.

Basically, I want my query results to look like:
NAME ADDRESS CITY
abc def Seattle
xyz lmnop Seattle
etc...

I want "City" to be manufactured field that gets created/populated when the query is ran. I'm sure this is possible, I just can't seem to get it to work! Thanks for any help,

-Andrew

 

[KenReay]

Hi

SELECT Name, Address, "Seatle" As City FROM ....

should do it

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[AndrewWolford]

That was it, thanks! (I knew it had to be something really simple that I was forgetting)... Thanks again!

-Andrew