Entering Data

  • Thread starter Thread starter tinab
  • Start date Start date
T

tinab

I need to extract records from another program based on a date search.
Each month I will do the same search with a different date range (ie.
in January I will extract records that will be six months later (July)
and five years ago (2000). I am saving this file on my computer as
Import.txt and will just overwrite it each month. I then import this
file into a Imported Records table. These imported records do not
contain a date field but I have added a date field when doing the
import and saved this import specification. Some of the customer names
have ############## in the field. I have created an update query to
change those records to say Home Owner in that field. How can I enter
the date that I used to extract the data (July 2000) from the other
program into the date field for all of the records? Or is there some
other way to accomplish what I need to do that I am not aware of.

Once completed I will then append these records to a Properties table.
I have set up a macro to delete the current import table and run the
import specification to import the new Import.txt file and make a new
Import table with the new records.
This is a new challenge for me and I am stumped.
Thanks, Tina
 
Hmmmmmm. I must be misreading your question because you are too far along
as an Access user to be asking what I think you are asking. If I understand
you right, you seem
to be asking how to take a set of records in a table that does not have a
date
field and add a date field and populate that date field with the same date
in
all records.
If that is correct, what I would do is open the table in design view and add
a date field.
Then I would design an update query that includes just that date field and
insert my date of
choice into the "Update To" row and run the query.
I can't possibly be reading this question right.

Ed
 
Back
Top