DLookUp in report - Urgent

[nshah1013]

I am tring to pull up value from a table to show on Report..

=DLookUp("STATE_ABBR","CODES_State","[CODES_State]![STATE] = Reports![Flagstar Summary Report]![STATE]")

This should show me the state abbriviation connected with the state code. but it is coming up blank..please help on what I am doing wrong. Urgent please.

 

[KenHigg]

=DLookUp("STATE_ABBR","CODES_State","[CODES_State]![STATE] = '" & Reports![Flagstar Summary Report]![STATE] & "'")


???

 

[Rich]

Makes more sense to add the look up table to the Reports underlying query so that you don't need to use DLookup at all

 

[KenHigg]

Makes more sense to add the look up table to the Reports underlying query so that you don't need to use DLookup at all

Guess we weren't urgent enough

 

[nshah1013]

Thanks a lot to both of you.

Ken..It worked the way you showed it. Really appritiate your help.

 

[Rich]

Ah well, some you win some you lose

 

[KenHigg]

Ah well, some you win some you lose

Even a blind squirrel will find a nut every now and again