Macro -Code ???

[Billionz]

Hi,

I have a table that I run a query on that using only 5 fields from the table. One field in the table is “Name” this is the only field that I define a criteria for.

All of this works fine but it is very time consuming because I have hundreds of names that I need to run queries on each day.

Can I get some ideas on how I would go about improving the efficiency of this procedure?

I was hoping that there would be some way of entering in the names in a list and have a macro or write some code that would automatically run the queries from the list.

My level of knowledge: I have been using Access for about 5 months, only tables and queries I still have a lot to learn. I can write some basic code in VB.

If anyone could give me some information to get me headed in the right direction it would be much appreciated.

Thanks for all of your help.

Bill

 

[The_Doc_Man]

With a side note: Don't use "Name" as a name of ANYTHING. It happens that "Name" is a reserved word. This can sometimes lead to confusion.

 

[Billionz]

Hi,

Thanks for all of your help.

I wasn't to clear on the first post so I am going to try to clear this up a little.

I will explain things a little more in depth.

- I have just 1 table that I am running these queries on.
- The table has every name in it already (plus I also have a list of the names that I am going to run queries on).
- I use only 4 fields in the query (student name)-(school)-(date)-(average)
- the only field that I select criteria for is (student name)
- there are thousands of students names
- I already have list of the (student names) they are in groups of ten
- I can easily copy and paste each group of ten
- The reason that I move the query information to Excel is to perform mathematical functions such as (std. Deviation)-(z scores)-(outliers) etc..


Below is kind of how I have the data in my Excel worksheet. I stopped at two students but on my worksheet it goes over 10 students.

Name----School----Date----Average---- Name-----School-----Date----Average
John___ Main ___ 10/2/02___ 97___ Jane ___ South___ 10/1/02___ 97
John___ Main ___ 10/2/02___ 74 ___ Jane ___ South ___ 10/1/02 ___ 89
John ___ Main ___ 10/2/02 ___ 90 ___ Jane ___ South___ 10/1/02___ 93___
John___ Main___ 10/2/02___ 77 ___ Jane___ South ___ 10/1/02___ 97
John___ Main ___ 10/2/02___ 88 ___ Jane ___ South ___ 10/1/02___ 82
John___ Main ___ 10/2/02___ 65 ___ Jane ___ South ___ 10/1/02___ 77

Again to just compare 10 students I am running a 10 queries one for each student, then I move each query one at a time to Excel.

Any help on improving this process would be greatly appreciated because on most days I am running over 100 small queries like this.

Thanks Bill

 

[Billionz]

Hi Pat,

Thanks for your help I will start working on this monday.

Bill