Recommendation on how to use semi-fixed variables in a Query

B

BobC

I need to use about 8-10 variables that will only 'seldom' change in the
calculations of query fields. Because the variables will be used in
multiple expressions within the query, it would seem to be best to only
have to change them/it in just one location. Should I use a table? The
variables will all be numbers (if that makes a difference?).
 
A

Allen Browne

Simplest solution might be to build the SQL statement, embedding the
variables, at the time you need it.

This would be a piece of code to OpenRecordset() and retrieve the rows you
need, and concatenate the values into the string. You could then assign the
SQL statement to the RecordSource of a form or report, or the SQL property
of the QueryDef.
 

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

VBA word change keys 0
How to Change criteria on a saved query using VBA 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Calaculating a column sum from within the same query 5
Check box results into a query 1
Use Same Variable multiple times in a query with different criteri 2
Can I use a number variable in a Query? 10
Trying to make a query that's based on a variable table name 2

Top