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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Lookups Problem

Status
Not open for further replies.
sopmac

sopmac

MIS
Jun 28, 2001
6
US
I am having problems with queries. I am trying to create a query that that refers to main data and then looks in a table for a specific figure. My table has fields for "symbol" and then several fields for "years" (2002, 2001, 2000,...). What I want to do with this table is lookup the "symbol" field with my main data table's "symbol" field and then if this symbol matches, I want to retrieve the figure from the "years" field that corresponds with a "year" field in my main data table. I am not sure what to use: nested iifs? dlookup? choose? switch? other? Any help will be greatly appreciated.

Thanks.
Ivan
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
317
Swi
Swi
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
150
dhookom
dhookom
lmcate
  • Locked
  • Question
Access Report - Save Report to multiple PDF's for each of the vendors 1
Replies
17
Views
384
Uncle Gizmo
Uncle Gizmo
cimoli
  • Locked
  • Question
Access Query IIF statement with multiple conditions 3
Replies
6
Views
368
cimoli
cimoli
breezett93
  • Locked
  • Question
Merging multiple records into just one 1
2
Replies
22
Views
216
breezett93
breezett93

Part and Inventory Search

Sponsor

Back
Top