Queries and Constants

[MikeAngelastro]

When ever I try to use a constant in a Query, the query treats it as a parameter. It asks the user to provide a value. Is this the way Access is designed? Or am I doing something wrong? Will I have to use a public function in order to use the constants?

 

[MikeAngelastro]

Thanks Pat. That's what I thought. It appears that the same is true for forms and reports as well.