added text to entire column in the Query

[Jerseynjphillypa]

So I am trying to create a Query using data from two tables.

But in the two tables there is no field called Location which are the same.

I want to create a new field in the Query that called Location to say New Jersey.

Also I don't want a dialong box to pop up and have to type this manually. I just want a contest filed that will automatically populate with New Jersey under the Location Field.

[pbaldy]

In design view in a new field:

Location: "New Jersey"

[Jerseynjphillypa]

Thanks..I kept putting it as a Expression.

[pbaldy]

Happy to help.