Can anyone help me with a problem.
Using the DESIGN QUERY screen in Access ... I defined this field from
an existing table .. opinion votes.
politic_need: Mid$([opinionvotes].[vote_demographics],13,1)
It returns a one-character value - from 'A' through 'G'
I'd like to create a new expression (a sub-query!?) in my query that
looks up a friendly LABEL for this field .. based on the contents of
another table..
something like SELECT politics_label FROM politics WHERE politics_code
= politic_need
BUT I keep getting errors when I try to create it!. Any ideas!?
see http://www.rcbuchanan.com/subquery.jpg
for SCREENSHOT! [tough to describe otherwise! :-) ]
Thanks for any help! This is driving me nuts!
Richard