Display ALL queries in SQL view and edit them

[Adik]

Hello guys,

I'm a new user of this forum, so firstly I'd like to say "hi" for all of you.

My question;
Is it possible to display ALL Access queries in SQL view and edit them in this way?

I'm asking about it, because I have a tool for checking many fields and one query checks one field, so I have a lot of queries. I'd like to manage them in easy way.

Do you have any ideas?

Thanks in advance!

[pbaldy]

Welcome! I'm not clear on what you're trying to do. You can loop queries in code and manipulate their SQL property. Do you have a lot of queries because each has a hard-coded criteria? If so, generally you should have a single parameter query, where the user enters the desired criteria at runtime.