Can I write separate query for text box?

[kjyang]

I have a report linked to a query. I also have a table called Constants:

Variable Value
Year 2001
... ...


I used "Year" to print the year number on my reports. Since "Year" is not available from the query used by the report, I was wondering if it is possible to create a Text Box and write an query in the Control Source field like this to extract the year:

SELECT Value FROM Constants WHERE Variable = "Year";

I tried doing this but it doesn't work. Is it possible to use queries in text boxes? Is there another way to get this done?

Thanks in advance.

 

[Maquis]

Are you just trying to print the current year? If so use =Year() in the textbox.

If not, then perhaps you can include the table containing the year in the query. Maq B-)
<insert witty signature here>