Query help!

  • Thread starter Thread starter Dion
  • Start date Start date
D

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top