>If a run a query on a table to select all of the records and then append a new record to the original table is there a quick way to include it in the already exisiting query, or do I have to redo the whole query?
>
>Thanks
>Matthew

Are just issuing a Select * from mytable? Or is this a SQL View type of query? (e.g., Create SQL View MyView as Select * from Mytable). If you just did a "Select * from" then you would have to re-issue the select statement. If this is a SQL View, then all you have to issue is the Requery() function.

Otherwise, the solution George and other(s) should work -- using the results table again to add records.