Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query from table
- Thread starter Steve1001
- Start date
assuming that the delivery area value is a numeric as it would be if it were a key and the weight is a numeric, the sql statement would look like:
dim arfname as integer
dim wght as long
sql = "SELECT " & arfname & " FROM TarrifTable WHERE Weight = " & wght
you may have to precondition the weight to fit it into the weights in the table.
dim arfname as integer
dim wght as long
sql = "SELECT " & arfname & " FROM TarrifTable WHERE Weight = " & wght
you may have to precondition the weight to fit it into the weights in the table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question