Use of global variables in Queries

[Guest]

Is there a way to set global variables in an Access database and use those
variables in queries, without having thoes variables reside in a table or
query being used ...

Example.. i have a rate that is used multiple times in the same query, and
other queries.. i don't want to use a prompts, and for accuracy, it would be
ideal to have this a constant i could control with one update...

thanks

Paul

 

[Amy Blankenship]

Sounds like you could use a single-row constants table, and define
relationships to the tables where the constants will be used.

HTH;

Amy

 

[Guest]

sorry.. got my answer from a previous inquiry

 

[Guest]

i thought of that.. but then i'd need to join to that table to get the
constant.. which means i'd have to modify the tables and queries to join to
that table.. something that's not worth the effort at this time

Thanks

 

[Guest]

You can refer to a global variable in a query, by creating a function in a
module that return tha variable

Function FunctionName()
FunctionName = VariableName
End Function

In the query you can refer to the function
Select * From MyTable Where FieldName = FunctionName()

 

[Amy Blankenship]

Depends...for instance, if you have to access your query from outside Access
(asp, for instance), this won't work.

-Amy

 

[Amy Blankenship]

You'd have to modify the queries anyway, if you created a variable. You
should not have to modify any tables.

-Amy