Passing single variable for different make queries

[sumantht2020]

Hi,

I have many access queries designed in such a way that if there is a word for example Like "mike" in the table then show the results in the query. There are different queries similar to this where they should take mike and display the results. now the problem is we need to show more results which also has like "mark" in it. Can we create a table putting these 2 variables into that table and passing them to all queries instead of manually adding "mark" to all the queries manually.

Thanks
Sumanth.T

 

[khawar]

You can alse creat a vba variable and get the value of variable through a function

alternatevily

you can store criteria in a table and use inner join to show only records for that criteria

 

[sumantht2020]

thanks for your quick reply... I am completely new to access.. May I know the procedure of how to create a table with 2 or more values and using inner join in the query..

Thanks
Sumanth.T

 

[sumantht2020]

any online tutorials also welcome please... so that I can learn by myself and implement it...

Thanks
Sumanth.T