Recent content by longhorn

Okay thank you very much. Also is it true for Microsoft Access 2010 that the query SQL limit is 64,000 characters?

There is the beginning of it. every time I add a new part it just adds another union and repeats the same thing

it keeps saying invalid file when I try to upload the word document

If the length is the reason even if I shorten the names of the fields that might help a little bit but not that much. Is there a way to increase the size of a query?

Thanks. I'm glad to be here It's 90,088 characters and it said the limit is 25,000 so I don't know what you suggest I do

I have a query that is giving me the error that the query is too complex. I have a list box on a form where I am selecting parts and sending them to a report. I have gone back to the tables where this information is made all of the field sizes smaller. I am able to select 42 parts and when I...