Lookup feature for Data table

  • Thread starter Thread starter Vu Tran
  • Start date Start date
V

Vu Tran

I have a table which has the milage between two cities.
The cities are alphabetical and are the same in the column
1 and row 1.

I can make a combo box which has the row cities and
another combo box which has the column cities. I would
like to understand how to get Access to look up the
correct value between two combo box inputs (ie. Baltimore
and Dallas and it would look up the intersection of the
two cities in the matrix which would contain the milage in
between)

Any help would be appreciated.

Thanks,

Vu Tran
 
Your data table is really a spreadsheet. A Crosstab if you will. Access
queries do not work well with data in this structure.

If all of the column names are the same as the row names, then just use the
rows to populate both. Otherwise, restructure your data to a more normlized
fashion.
 
Back
Top