Adding one value to every record in a table in MS Access

Someone just asked me how to do this so I am going to post my solution in case it will help others…

Situation: You have a table of email addresses (and that’s it) of clients from the Boston DMA. You want to add a new field called DMA and assign all records the value of “Boston”

Solution: Make a query that includes your email address table. Include email address as one filed and add a new one. The new one will be called DMA and have a value of “Boston”. The SQL would look something like this…

SELECT [EmailList].emailaddress, “Boston” AS DMA
FROM [EmailList];

another option that would make a new table (called dmatable) for the info would be…

SELECT [EmailList].emailaddress, “Boston” AS DMA INTO dmatable
FROM [EmailList];