adding fields with fixed text

[Tim Donaldson]

I have a table generated by a query, and I'd like to add two new field
columns to the end or to generate a query which has the same effect.
One field is to be called "company" and has the word "pepsi" running
down all the rows of the column. The 2nd field is to be called "person"
and has the word "A.B." running down all the rows of the columns. How
could I do this?

Thanks. Tim Donaldson

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[MGFoster]

Include the column names and values in the make-table query. E.g.:

SELECT "Pepsi" As Company, "A.B." As Person, ... etc. ...

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Tim Donaldson wrote:

I have a table generated by a query, and I'd like to add two new field
columns to the end or to generate a query which has the same effect.
One field is to be called "company" and has the word "pepsi" running
down all the rows of the column. The 2nd field is to be called "person"
and has the word "A.B." running down all the rows of the columns. How
could I do this?

[Tim Donaldson]

MGFoster,

Thanks for the reply. I tried what you suggested, but it didn't seem to
work. It's not clear to me how this works. I have a table with already
four columns created by a query. Do I go into into design mode and do
something there, or should I pull up the SQL code and add some lines. I
tried adding some lines to the SQL code, but was coming up with an
error.

Also do I need to create field headings for the new fields first and
then add the fixed text to all the rows in a second step? Thanks for
the clarification.

Tim
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you don't want to re-run your make-table query you can use ALTER
TABLE instructions to add the new columns. Then run UPDATE queries to
add the "Pepsi" & "A.B." E.g.:

Add the new columns (2 DDL statements - 2 separate querys)

ALTER TABLE table_name ADD COLUMN Company TEXT(10);

ALTER TABLE table_name ADD COLUMN Person TEXT(10);

Fill columns w/ new value (an UPDATE query)

UPDATE table_name
SET Company = "Pepsi", Person = "A.B."

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQYgn1oechKq OuFEgEQI5kgCfUO RQzJNqaLGbY/NQKE4pec45rPAAo Mxs
+UFLXWuIlhbgOEx Eo7wN1OBQ
=6irL
-----END PGP SIGNATURE-----
Tim Donaldson wrote:

MGFoster,

Thanks for the reply. I tried what you suggested, but it didn't seem to
work. It's not clear to me how this works. I have a table with already
four columns created by a query. Do I go into into design mode and do
something there, or should I pull up the SQL code and add some lines. I
tried adding some lines to the SQL code, but was coming up with an
error.

Also do I need to create field headings for the new fields first and
then add the fixed text to all the rows in a second step? Thanks for
the clarification.

[Tim Donaldson]

MGFoster,

Sorry to not be understanding this yet. Maybe, I should start at the
very beginning. Is this it?

1) Create the query which creates my table ie. a table with 4 fields.

2) Once my query works and creates the table with 4 fields, highlight
the query and go to design view.

3) from design view, go to sql code.

4) add to whatever sql code has been generated there - add the SQL codes
which you are suggesting here. These codes will a) create the new fields
with field headings b) fill in the new columns with the specified.
word/s.

Thanks.
Tim


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!