Add a field to a table and fill it

[oliver_penney]

hi

this is probably dead easy, but i'm sick of wading throught the help file

in VBA, how do i add a field to a table, name it "xxx" and fill it with "yyy"

"yyy" is the same for all records, so that should make it easier

thanx in advance

ol

 

[Corticus]

Do you need to store the 'yyy'?

Probably not.

I would use a query,

Make a new query, insert your table and fields you need, then add a new field like this:
XXX: "YYY"
and it will fill down for every record.
The SQL is as follows:
SELECT TblOliver.ID, TblOliver.Field1, "YYY" AS XXX
FROM TblOliver;

Replace TblOliver with your table name and Field1 with your field(s) name(s).

This is a better method than storing the "YYY" because it uses no memory.

If you absolutely need to store the "YYY"s in a table, add a field to TblOliver (or whatever you call it), and call the field "XXX", and make it a 3 character text field.

Now, use SQL as follows to add "YYY" to each record in this table.
UPDATE TblOliver SET TblOliver.XXX = "YYY";

HTH,

 

[oliver_penney]

i got it in the end, i used something like your second method

it was more complicated than "YYY" in each table, essentially i was populating the field with the table name, so that when i UNIONed all of them together i could tell where they came from

i used CreatField and then i used a update bit of SQL

*phew*

thanx