Recent content by eng3
-
E
Query Design View: Show results in two columns from one table
Ah, just drag it in twice. I see. Thanks -
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... -
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 |...