Converting numeric field to the descriptive field in a different file.

[parsok]

I have a query with a field in a file called account flag. This is a numeric value. In another file, called accounting flags is a field with the numeric value and another field called description. From a query I would like for the user to see the description rather than the numeric value. (I know this should be simple and I'm trying to learn access 2000.) Also the two files don't have a relationship.

Any information will be appreciated and thanks in advance.

:

 

[tlbroadbent]

You can Join tables that have a common column even if you haven't defined the relationship.

Select
[a].[Account Flag], .[Description],
<more fields>
From Table1 As a
Inner Join [Accounting Flags] As b
On [a].[Account Flag]=.[Account Flag] Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com