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.