Recent content by craisbeck@boxlogixautomat

True, Table 1 has about 40 fields.

I could union all it and normailize it. I didnt control that table structure so I am workign from behind a bit to start with.

I have 2 tables. Table1 Reg#,CED%, WW%, YW% 100,5%,5%,15% 101,7%,4%,10% 102,10%,6%,10% Table 2 EPD,%,Val CED,5%,12 CED,6%,14 CED,7%,16 CED,10%,25 WW,4%,2 WW,5%,4 WW,6%,6 WW,10%,5 YW,10%,1 YW,15%,2 I am looking to get a query that would create the following result set comparable to a lookup...