Search results

Good idea. I think I am going to pull from another source with alot of that information in it. My next question, can I do this again and again with multiple tables? Say I have 10 different panel databases (hoping not to do that), but can I merge all of them into the same sheet? Or did I jsut...

Sigh....I'm an idot. Now on to the next part. Probably be back soon :confused: Thanks, George

Well, I made my first union table (not too bad), but I'm getting a pop up box asking me to type in a Panel Id (parameter value). Is there a way to kick out this report while getting all the Panel Id's on 1 query? Here is what I have: SELECT J1 AS Module, Panel_ID FROM Panels UNION SELECT J2...

I may be in the wrong forum, and if so, I apologize. If there was a similar example, I'm happy to search if someone could give me my search term. Anyway, heres what I'm trying to do I have 1 database table with a bunch of items in it (in the fourth field) The second database table has a list...