Adding Existing Data to a Table

[Guest]

I have a various tables that track the cost by carrier of a call to a certain
number. Unfortunately, I forgot to add the carrier name as a record in the
table. Now I want to put all of these tables together and do a crosstab
query, but there is no way to indentify which carrier relates to which rates.

As such, I want to add a field to each table titled "Carrier_Name" and
somehow populate each of the 10,000 records with the same name (ie. AT&T). I
thought I know how to do this once, but can't recall.

Can anybody help?

Thanks,
Craig

 

[Guest]

UPDATE Table SET Table.Carrier_Name = "AT&T"
WITH OWNERACCESS OPTION;

 

[John Vinson]

As such, I want to add a field to each table titled "Carrier_Name" and
somehow populate each of the 10,000 records with the same name (ie. AT&T). I
thought I know how to do this once, but can't recall.

Add the field in table design mode.

Run an Update query to update it.

And if you have a different table for each carrier... consider then
running a bunch of Append queries so you have ONE table, with this
Carrier_Name field (indexed for efficiency), and use Queries based on
this one big table rather than having separate tables!

John W. Vinson[MVP]