Constants in queries

's Computer Specifications

Hi

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

Thanks

Regards

's Computer Specifications

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
---------------------------

"John" <(E-Mail Removed)> wrote in message
news:uUb%(E-Mail Removed)...
> Hi
>
> I have defined global constants in a module. How can I access these
> constants in a query?
>
> Thanks
>
> Regards
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Constants in queries	John	Microsoft Access Queries	1	14th May 2006 12:55 AM
Queries and the functions, operators, constants, etc.	=?Utf-8?B?SnVkeQ==?=	Microsoft Access Queries	1	30th Dec 2005 02:25 AM
Constants in VBA	Don	Microsoft Access Form Coding	3	20th Feb 2005 07:22 PM
constants	=?Utf-8?B?YWxla20=?=	Microsoft Excel Programming	1	9th Sep 2004 12:16 PM
integer constants used with string constants	Eric Newton	Microsoft Dot NET Framework	3	14th Jan 2004 05:05 AM