Declare a variable to be used in queries 1

[ovs8]

Is there a way to declare a variable that could be used in multiple queries (including UNION queries), such as 'Start date' and/or 'End Date'. Do I have to bring all SQL statements into modules for that?

thanks,
oleg

 

[rubbernilly]

You can have a global variable set in a module.

To reference it in the criteria of an equation, create a function of the appropriate type that returns the value.

for instance, put in a public module:

Public iMyVar as integer

Public Function GetiMyVar() as integer

GetiMyVar = iMyVar

End Function

of course, you can set that up with arguments if you needed to pass in query-specific information and return different mods of the initial value.


Alternately, you could have a table of INI type information, and do a DLookup on that table. Setup a table with an autonumber index, a text field called "Type" and a text field called "ArgValue1" (you can have several for more complex lookups).

You could put an entry in the table for

A#: (Autonumber)
Type: Sales
ArgValue1: 2

your Dlookup would be then:

=DLookup("ArgValue1","YourTableName","Type = Sales")

HTH

 

[rubbernilly]

above should read:

to reference it in the criteria of a query.

Sorry.