Search results

  1. E

    Query Design View: Show results in two columns from one table

    Ah, just drag it in twice. I see. Thanks
  2. E

    Query Design View: Show results in two columns from one table

    No, I need the output to be like I showed in the first post I think I found a way. This may not be the best way (using the GUI) I create Query for each sub query. On TopQuery: SELECT outfits.TopColorID, Colors.Color FROM Colors INNER JOIN outfits ON Colors.ID = outfits.TopColorID...
  3. E

    Query Design View: Show results in two columns from one table

    Lets say I have the follow Tables: Outfits: ID | Top Color ID | Bottom Color ID 1 2 1 2 3 4 Colors: ID | Name 1 Red 2 Blue 3 Green 4 Orange I'd like to have a query in design view to have the following result Outfit ID |...
Back
Top Bottom