How to make a chosen field from table a value for query criteria?

[Jimmy Jones]

Hello,

I created a table with only two columns "Month" and "FY". The table has only one row. The purpose is to change two cells content:

- once a month ("Month") and
- once a year ("FY")...

... as an admin. My idea was to take these values and use them as criteria in a query that could show me only records for the month chosen by me in "Month" column.

How make the query recognize the value of the "Month"?
Usuall "directory" like:

[tbl_CurrentMont h]![Month]

simply does not work...

I would really appreciate some suggestions!

Thanks !

[nico5038]

Looks like a duplicate posting from Mike Watson, but this is different user. What's happening here ?

Nic;o)

[Jimmy Jones]

I apologize, you can delete this POST!!!