How code this query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 2 columns both links to other tables containing
descriptions for the ids. I need a query to provide a recordsource for a form
that returns the 2 columns of the table (not the descriptions) but sorted by
the descriptions instead of the codes. Any ideas?
e.g.
table 1:
code1=1, code2=1
table 2 (descriptions for code1)
1 = B
2 = A
table 3 (descriptions for code2)
1 = Y
2 = X
 
Explain why you can't include the two other tables in the form's record
source. I doubt you can sort a form based on a field that isn't in the
form's record source query.
 
Back
Top