MS97 - Update Query - Table Driven Criteria

  • Thread starter Thread starter Ross H
  • Start date Start date
R

Ross H

Is there a way that I can create a table with criteria pre-
set in it, and run an update query that would select the
criteria in that table, and perform the update?

I would like to setup a table called Tbl_Update Rates
Criteria. Create a query called Update Rates, and within
the query criteria, refer to fields in Tbl_Update Rates
table to run through all of the scenarios for an update
against a table called tbl_decision matrix.

Any help is greatly appreciated!
 
An Update Query cannot Select anything, only Update. A Select query can
select.

A default value will populate a field, in a table, with a desired value.

It sounds like you're updating the US dollar vs. other currency or stock
prices, etc.

This is very easy to do in an Update Query, as you only need to link the two
tables together by their common field. StockID, CurrencyID, etc.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
That notation does not exist for tables, only forms and reports.

You would need to include the table in the query, and perform a link. Or if
you just want one value you could use Dlookup().

The sequential steps would probably need to be controled by a VBA proc

Ross H said:
Steve, thanks for the response.

I tend to abuse the terminology. I would like the
criteria in an update query refer to a table and it's
fields. Similar to the way I would link criteria to data
in a form by inserting [Forms]![Form_Name]![Field_Name]
into the criteria section, I would like to link to a table
and it's fields to run through specific criteria within
the table and run the update. I'm thinking that I could
add the line [Tables]![Table_Name]![Field Name] to
accomplish this, however, after running this criteria, I
want Access to commit the changes before looking at the
next line in the table.

Specifically, I receive mortgage note rates across 120
products each month, whereby I need to update over 3000
rows of rate data appearing within a decision engine table
that refers into the product table. What I would like to
do is create a sequential criteria/update query, that
would run down the specific parameters within the decision
matrix and update the appropriate rates.

Hope this helps, your feedback is appreciated.

-----Original Message-----
An Update Query cannot Select anything, only Update. A Select query can
select.

A default value will populate a field, in a table, with a desired value.

It sounds like you're updating the US dollar vs. other currency or stock
prices, etc.

This is very easy to do in an Update Query, as you only need to link the two
tables together by their common field. StockID, CurrencyID, etc.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-




.
Click to expand...
Click to expand...
 
Back
Top