Query help!

[Dion]

I have a query that will get one of several results from
a field in the table it is querying (25,36,56,63,89,99)
and give me a different result in another field.
For example, I want:
FieldA FieldB
25 = 36
36 = 25
56 = 63
63 = 56
89 = 99
99 = 89

 

[[MVP] S. Clark]

You'll need to explain more throughly. Feel free to post the table
structures for clarification.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-