Inherited an Access DB that has queries labelled as MMM-YYYY. How to create a macro just to run queries for 'JAN' or prompted month?

[MikeL]

Queries are similar to:
TEST JAN-2022
TEST FEB-22
FILE JAN-23
All contain a text string with the month ie JAN or FEB

Need syntax and process to create a macro to run only queries with month entered at Prompt

Thanks in advance

 

[MikeL]

I need a VBA/SQL solution to search for