I've recently inherited an access database that I am trying to do some reporting on. One of the tables has the following structure:
Att_ID Type Values 410 Color Blue 410 Color Orange 410 Color Black 410 Color Olive Drab (green) 410 Size Large 410 Size XX-Large 410 Size X-Large 410 Size Medium 410 Size Small 410 Diam .35 411 Color Blue 411 Color Orange 411 Color Black 411 Color Olive Drab (green) 411 Size Large 411 Size Medium 411 Size Small 411 Diam .35 411 Diam .32 411 Mat Wool I'm trying to qry to be able to display all combinations of all Types per Att_ID, i.e: Blue - Large - .35 Blue - XX-Large - .35 Blue - X-Large - .35 Blue - Medium - .35 Blue - Small - .35 Orange - Large - .35 Orange - XX-Large - .35 Etc.. I can do this with some qrys and logic using self joins, but my issue is each ID can have differing numbers of Types, so the number of self joins would vary. Anyone have any hints on a way to accomplish this easily? Thanks, Scott --- [This E-mail scanned for viruses by Declude Virus. Service provided by Accurate Imaging, Inc.] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
