Too many queries?!

[coach.32]

Hi I am using Access 2003.
I have created 50 Select queries that have all the same fields except for one. I copied and pasted the query each time and changed the one field for each copy thus ending up with the 50 queries. I was wondering if there is a simpler way to do this. I have very limited knowledge of VBA but I am very keen to improve that knowledge. Any help would be greatly appreciated.

 

[pbaldy]

Probably; what is the last field and where is it coming from?

 

[coach.32]

They are all taken from the one table. EG: The fields are - Team Id, Activity, Status, Priority and Complexity. The only field that I need to change in each query is the Team Id (eg: 1744, 1746, 32477 etc.). The others stay the same. Thank you in advance for any guidance.

 

[pbaldy]

You mean you're changing the criteria so the query only pulls the applicable team? In that case, you just want one parameter query. At it's simplest you put

[Enter team ID]

in the criteria row under the team ID field, and the query will prompt the user. Most of us that develop for a living use a form to gather user input, which would look like this in the criteria:

Forms!FormName.TextboxName