Access 2007 database

[David Donaldson]

I am using access 2007 for an employee database.
I have one table called worker classifications. (ie. cft2 is a labourer and
cft3 is a concrete finisher)
we have 3 districts that we are going to streamline into one format. the
other districts use other classifications. is there a process to find all
files with a certain classification and automatically change them without
having to open each workers data?(would have to open 4000 files and change
manually)

any help would be appreciated.... David

 

[Larry Daugherty]

If by "file" you actually mean "record" then, Yes. Use an Update
Query.

If that's not the case then you need to more carefully describe the
structure of your data and what you're trying to do. Please use the
accepted names of things such as Files, Records, Fields, Controls,
etc. the names have very specific meanings.

HTH

 

[Tom Wickerath]

To add some to Larry's answer, you might want to have a look at this article
on Office Online:

Change existing data by using an update query
http://office.microsoft.com/en-us/access/HP051880881033.aspx

Although written for Access 2003, the concept applies to any version of
Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

If by "file" you actually mean "record" then, Yes. Use an Update
Query.

If that's not the case then you need to more carefully describe the
structure of your data and what you're trying to do. Please use the
accepted names of things such as Files, Records, Fields, Controls,
etc. the names have very specific meanings.

HTH
--
-Larry-
__________________________________________

message
I am using access 2007 for an employee database.
I have one table called worker classifications. (ie. cft2 is a labourer and
cft3 is a concrete finisher)
we have 3 districts that we are going to streamline into one format. the
other districts use other classifications. is there a process to find all
files with a certain classification and automatically change them without
having to open each workers data?(would have to open 4000 files and change
manually)

any help would be appreciated.... David