Phil If you aren't able to pull up a copy via the approaches Smartin offers, are you willing to step away from it and just re-do the queries? I suppose another possibility (though lower likelihood of success) would be to open a new Access database and attempt to import the offending query. Have you already saved a backup copy and run Compact & Repair. Regards Jeff Boyce Microsoft

I'm in Design View. When I try to go to SQL View it won't let me because of the error. Can I get around this? Sorry, I'm a newbie. Phil "Jeff Boyce" wrote: Phil If you don't post a copy of the SQL, we can only guess... Regards Jeff Boyce Microsoft Office/Access MVP "Phil" <Phil@discussions.microsoft.com> wrote in message news:710EED7C-959B-4102-BA4D

I have a standalone query that works. When I cut and paste it into an existing query that works I start getting a parenthasis error. It says I have an extra closing parenthasis ")". I have two pairs of them. Just to test I took each one out individually and each time it tells me I'm missing a closing parenthasis. I'm guessing its a badly worded IBM error message. Any idea what is wrong?

Hi Albert, Here's what I ended up with. There are just a few anomalies which we can manage manually. Thanks for all your help. Dan Sub test9997() 'First Part number in parenethasis On Error Resume Next Dim colFiles As New Collection 'To hold file names Dim strFile As Variant 'To capture the file hame Dim intFile As Integer 'To count

Hi Jeff, My big problem right now is that I don't know how to find the line in the file that holds the part number. I've been attempting to loop through the file looking for a parenthasis, but I haven't figured out how yet. For Each strFile In colFiles strPath = Left(strFile, InStrRev(strFile, "\")) 'Close intFile 'Close strFile Open strFile For Input As