Looking up Values in Access Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have "Table A" with various Sales %'s, such as 104%, 111.5%, 121%, etc. In
"Table B", I have grid with 2 columns. One column has Sales %, the 2nd
column has values assigned to them. Such as 100% in column 1. Column 2 has
$84. Next record is 105% in column 1, Column 2 has $96. For example, I want
to have a query that will take 104% in Table A and Look Up that value in
Table B and assign $84 to that value. Basically looking at assigning a
Dollar amount to a Sales Percent. What function would I use? What would the
field in the query look like? Thanks.
 
I assume you are trying to put the value from Table B into a column in Table
A? Your query would be:

UPDATE TableA SET column_name = table_b_column_name INNER JOIN TableB ON
TableA.sales_percent_cloumn = TableB.sales_percent_column

Replace column_name, table_b_column_name, and sales_percent_column with the
appropriate names from your database.
 
I was looking to do this with a formula in an Access query. On your code
below, where would I apply that in Access? Thanks.
 
Back
Top