469,133 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

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

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_CurrentMonth]![Month]

simply does not work...

I would really appreciate some suggestions!

Thanks !
Oct 18 '10 #1
2 725
nico5038
3,080 Expert 2GB
Looks like a duplicate posting from Mike Watson, but this is different user. What's happening here ?

Nic;o)
Oct 18 '10 #2
I apologize, you can delete this POST!!!
Oct 18 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ray Holtz | last post: by
5 posts views Thread by epost2 | last post: by
1 post views Thread by Coll | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.