Inner Join Query Questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Wetmore - 26 Apr 2008 02:01 GMT

The VBA documentation says that UNION queries can use SQL statements as data sources.
The documentaion on JOIN queries implies that tables must be used as data sources in JOIN queries.
If this is correct, what is the most efficient way to create a table in VBA and move a recordset into it?

Thanks,
Dave

Reply to this Message

Rick Brandt - 26 Apr 2008 02:48 GMT

> The VBA documentation says that UNION queries can use SQL statements
> as data sources.

All queries use SQL statements. SOME queries can also be represented in the
graphical query designer. UNION queries happen to be one of the categories
that cannot be thus the only way to build them is in SQL view of the query
designer.

> The documentaion on JOIN queries implies that tables must be used as
> data sources in JOIN queries.

Incorrect. A query that uses a join can consist of tables, saved queries,
or SQL statements.

> If this is correct, what is the most efficient way to create a table
> in VBA and move a recordset into it?

I suppose the "most efficient" in the sense that it requires the least
amount of code to type would be to execute a SQL statement that is a
make-table query. Most efficient in terms of system resources or speed
would be difficult to say positively without actual testing.

As described, it is unusual to need or want to "move a recordset into" a
table.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message