Adding a column that doesn't exist in the table, to the query 1

[KristieLee1]

Greetings all. Hope this is the right spot for my question.

I am creating a query in access off of one table. The table I am using does not contain the required code of AB01. This code should appear on all rows of returned data. I am not allowed to add this code directly to the Access table, but I must return this code when the query results are presented.

How can I add what I think would be a calculated column to display this code in a column on each row, since the field does not exist in the table itself?

Any help is appreciated. Thank you!

 

[ICCIIT]

Insert or Add new column called MyCol:"AB01"

This will then add the text to all records returned by your query.

 

[KristieLee1]

I can add it that way to the query? I can not modify the table structure.

 

[KristieLee1]

SWEET!!! I just did it. Thank you very much for your fast response. I appreciate it!!!

 

[ICCIIT]

Easy but only when you know how!

You can expand on this with all sorts of formula's/functions etc and is very helpful when enriching existing data tables or creating new tables

Glad to help...

 

[msaccessqueries]

Hi,

I did not post the question but the answer of ICCIIT is very helpful to me.

It would be beneficial to me in terms of populating my MakeTable Query with a new column with my desired values, thus expanding the capability of this query technique, thank you very much!



Accomplish work in a Flash with
MS Access Queries!

http://www.msaccessqueries.com

 

[ICCIIT]

Glad the posting has helped - wow makes me feel good too!