ok looks like I need to give you a more information on the data.. the original table is a read-only CD - that is correct and contains several thousand records - I'm interested in about 10 I use the query->select function to build the query and select the records I need to work with in this case 'query2' once I've created my selection I then go to file->save copy as... and select my query - 'query 2' the error message is "unable to create new table"
I just redid the steps I went through to make sure I wasn't missing anything. So what am I doing that isn't correct?? Barbara ----- Original Message ----- From: Patrick Chance To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 7:48 AM Subject: Re: MI-L saving query to a separate editable table Barbara You should be able to save the query, using "Save Copy As", if you select the Query, at the bottom of the file list if it was your most recent query. It seems that you may be trying to save the original file, which being open cannot be saved as itself. Patrick On 4/7/2004 10:41:50 AM, Barbara H. Carroll ([EMAIL PROTECTED]) wrote: > I have a query that > I'd like to save as a separate table that I can then edit and manipulate separately. When I try to save it using 'save > copy as...' I get an error. and when I use the 'save query' command, it's > saved as a query that's linked back to the original table that I can't > edit. How do I get this to work?? > > Barbara Carroll
