Calculation In Query

[Hal]

I am new to Access, and am unsure how to run a calculation based off data in
my table using a query. I have 2 multi-column lookup fields in my table and
want to divide one by the other. I have a feeling that Access is trying to
use the data from the other column in the multi-column lookup. How do I make
certain that Access is only looking at the data that shows in the field to
perform the calculation? For instance, the multi-column looks up 1234 in the
first column of the drop-down and has 5678 in the second portion. When you
click it 1234 shows in the field, this is what I want it to do. But I have a
feeling that when the calculations in the query are performed, 5678 is
messing it up. How do I get it to only read 1234?

 

[Allen Browne]

The combo box must get the data from its columns from another table/query.
Include that table/query as a source 'table' in this query. You will then
have the fields you need available, and be able to perform the calcuation.

Or perhaps you are talking about multi-valued fields in Access 2007? That's
a whole other ballgame, because Access does not expose the tables where
these values are stored, so things change if you try to extract them from
this one table.