Search results

No Null values. Assume you have read the other updates since this to see how its progressing.

Not using Quotes. Just put that in the message to emphasize the value. The query works with the values I added, it is just that when you look at the results and try to sort the field, then that syntax message comes up. Once you click OK on the error message box then the sort /filter option...

I also seen a Name AutoCorrect Save Failures. But it shows the old corrupted table as not being able to be saved. The feature under OPTIONS does show this has been disabled though.

Pat, I did that but still have the problem. One query has the criteria as being ">12/31/18" under a Date field. That was how the original query was before the table1 went corrupt. If I change that to ">12/30/18" then I get this error when trying to sort the data. The query actually runs...

I had a database where the primary table (call it table1) became corrupt. I could not open it, yet the queries I created that linked to the table1 still worked. At this time I was adding more fields to the table and subsequently to the From that fed the table. After I added those then the...

Not even sure what Version of Access. Whatever was in use back in the 1990's.

Hello Everyone. My name is Ron and I live in Waco, TX. I have used Access for about 25 years but am by no means an expert or a programmer. I design relatively simple databases for users to enter data and do simple queries and reports. I originally am from Minnesota and lived there 38...