I'v started creating a new query table but have found myself using a lot of constants within my queries. These constants or "magic number" may need to change globally.

I was wondering what the best way to handle constants/magic numbers withing qiery tables.

One option is to create a table call "My_Report_Variables" with two columns "Constants Name" and "Constants Data". I could then lookup the "Constants Name" to get the data. In the future, if the values of these global constats change, I only need to modify the value on the "My_report_Variables" table.

However, Im not sure of the best way to select multiple values from the "My_Report_Variables" table for use in a single query table.

Any help is much appreciated.

Thanks,

Nish