First let me say that I believe I am having a mental block as to the simplicity of this question. Hopefully you have all had a day like this so I am not too embarrased. I have a database that is linked to 13 tables. Each table has the same 7 fields. I simply want a query to look at all 13 tables, look in a specific field and provide a list of items that match that criteria. I am ok with a make table query if you believe that is the simplest way to do it. Once I have the data I will create a report from this item and all should be well.
I have attempted join queries and make table queries but the confusion begins due to the fact that the field names are the same between tables. My SQL capabilites are low so if I can avoid that it would be greatly appreciated.
The tables do not have a key as they are Excel spreadsheets that are updated separately.
Once again thank you for your time and I know this is simple, I just seem to be banging the ol noggin on the wall for some unknown reason.
I have attempted join queries and make table queries but the confusion begins due to the fact that the field names are the same between tables. My SQL capabilites are low so if I can avoid that it would be greatly appreciated.
The tables do not have a key as they are Excel spreadsheets that are updated separately.
Once again thank you for your time and I know this is simple, I just seem to be banging the ol noggin on the wall for some unknown reason.
Last edited:
Thanks again!