[AccessD] Turn a recordset into an actual table

Arthur Fuller fuller.artful at gmail.com
Mon Oct 18 11:33:23 CDT 2021


Thanks guys.

A.

On Mon, Oct 18, 2021 at 10:32 AM Rocky Smolin <rockysmolin2 at gmail.com>
wrote:

> I would use a make table query that is the same as the query you use to
> open the recordset. Just don't forget to clean up after yourself - delete
> the table when done.  Alternatively you can put the recordset records into
> a table with an append query - again, delete all records in the target
> table before the append to insure thatr you're only looking at the records
> from the recordset.
>
> HTH
>
> r
>
> On Mon, Oct 18, 2021 at 3:49 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > Is there a way to turn a recordset into a table? I hate not being able to
> > browse the RS and see what it contains.
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list