Entering same value repeatedly

  • Thread starter Thread starter Michael Bentfeld
  • Start date Start date
M

Michael Bentfeld

Hello,

I've got a database used to track sales. I periodically
import data from an outside database, but this data
doesn't contain dates, which I need for the database to
work. I have been entering the dates manually by entering
the date in the first record, then copying and pasting to
the other records that were imported (since all these
records took place on the same date). I thought about
setting a default value for the date field, but the sales
didn't take place on today's date. Is there a way I can
set up Access so that when I import records into this
database, I can enter the date for all the imported
records at once? I want to enter the date into one
imported record, and have it appear in all of the records
that were imported at that time. Thanks.

Michael
 
You could use an update query ...

UPDATE YourTableNameHere SET YourFieldNameHere = [Enter Date]
WHERE YourFieldNameHere Is Null

When run, this will prompt you to enter a date, and put the date you enter
into the specified field for all records that have no value in that field.
 
Back
Top