Query

[Eddyoftheyear]

Hi,

I have a query result that I would like to add a value in a new column in the query result. Example of the query result is

Name DOB Dept Division

But I want to add another field which is not in the table showing the word Domestic in each records without inserting it in the table. Is there a way to do this?

 

[PHV]

SELECT [Name], DOB, Dept, Division, 'Domestic' AS AnotherField
FROM yourTable


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886