Windows XP 
Access 2003
I have a query where I have a position number and its authorization code which is a 0 or a 1. The positions ends then maps to a second position in the same query which a different position number with an authorization code of 0 or 1.
Looks like this:
Position 123 Auth Code 0, Mapped to Position 234 Auth Code 1 (but could be 0)
How do I get a separate field on the same query with the auth code for the mapped to Position?
Help!!
Reply With Quote
