repetitive entries

  • Thread starter Thread starter Gayle Hansen
  • Start date Start date
G

Gayle Hansen

I wondered if there was a way in Access (200) to do a
filter and fill in one field identically in the subset --
e.g. do a repetitive entry for everything in the filter?
I am familiar with the control quote routine for repeating
one field -- but I have thousands of entries to make and a
blanket repeat in this manner would really save time.

Gayle
 
You can execute an update query based on the criteria used to specify the
particular records that need the value entered.

For example if you have a criteria that all persons hired after 10/1/02 have
the value 'exempt' added to a field called Status; then you create an update
query add the field STATUS and HIREDATE to the query. Add Exempt to the:
Update To: cell under STATUS and in the criteria add >=10/1/02 under the
HIREDATE field. Run the query, it will update status to have the value
exempt for every person hired after 10/1/02. Since you are only updating a
single field not all fields are needed in the query.

This should give you enough info to set up your own update query.
 
Back
Top