Automating a Query over and over again

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to select a group of records with the same text attribute within a field without having to specify that field in the query? Now I know you will probably ask, "then how would Access know what to look for?" But I already know that you can sort records based on a common attribute within a field. However, if you have 500 different attributes for a given field it would be laborious and time-consuming to have to manually input each one into the query, run the query, save the query, and then do it ALL over again until all, say, 2000 records had been partitioned to their proper group.

So my solution would be to sort records based on a common attribute in this field over and over again, having the computer save the results from the query and then repeat the process untill all records had been placed based on the attribute. Is there a way to automate this task in Microsoft Access?
 
Maybe a more specific example will net an answer??

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Nathan said:
Is there a way to select a group of records with the same text attribute
Click to expand...
within a field without having to specify that field in the query? Now I
know you will probably ask, "then how would Access know what to look for?"
But I already know that you can sort records based on a common attribute
within a field. However, if you have 500 different attributes for a given
field it would be laborious and time-consuming to have to manually input
each one into the query, run the query, save the query, and then do it ALL
over again until all, say, 2000 records had been partitioned to their proper
group.
So my solution would be to sort records based on a common attribute in
Click to expand...
this field over and over again, having the computer save the results from
the query and then repeat the process untill all records had been placed
based on the attribute. Is there a way to automate this task in Microsoft
Access?
 
Back
Top