Adding a value to a new field in Access

[thebski]

Hey all,

New to the forum here and pretty much new to Access in general. I'm importing a text file into Access. The file is just a string of numbers that I'm breaking apart into three fields. Once those three fields have been broken apart by the import tool I need to add a new field that just contains the year.

For example, I import the 1990 data file that is .txt format and I break apart the three fields while it's imported. Once imported into three fields, I want to add a 4th field that says 1990 for every record. This has to be a pretty simple thing to do, but I can't figure out how to add a single number as a new field to every record in the database.

Any suggestions? Thanks guys!

[ssanfu]

Import one text file at a time. After the file is imported, execute an update query to set the field to the year.

UPDATE YourTable SET YourField = 1990 WHERE YourTable.YourField IS NULL

You can set this up in the query design grid.

[thebski]

Import one text file at a time. After the file is imported, execute an update query to set the field to the year.

UPDATE YourTable SET YourField = 1990 WHERE YourTable.YourField IS NULL

You can set this up in the query design grid.

It worked wonderfully. Thank you so much sir!!