Adding Existing Data to a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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]
 
Back
Top