Re: linking two tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Greg wrote:
hi Karl,
Thank you for your response. I'm getting "Query is too complex" when creating TableX_Roll and Table_Y_Roll as i have 130 columns across (data below is just a small sample)

is there any workaround?

I could be mistaken here but if you have a table with 130 columns I would say that your table structure is "probably" incorrect. It's not uncommon for users of Excel to misunderstand how the tables need to be set up. Look up the term normalization. It confused me completely when I first started out.

gls858
.



Relevant Pages