Constants in queries

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have defined global constants in a module. How can I access these
constants in a query?

Thanks

Regards
 
John,

You'll need to create a public function which returns the vallue of the
constant. Call this function in your query.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Global Constant values 1
Best (Easiest) to Multiply Columns by a Constant? 7
Constant value in queries 3
name references 11
How do i make a constant for query use? 7
Getting Windows System Colors 1
Microsoft Access Mail Merge with Constant Contact 0
Yearly Updates of Access Application 4

Back
Top