Re: Create a recordset based on another recordset

Take a look at Querydef in the Help file. You need to use QueryDef to define
one or both of your queries, one or both of your crosstab queries or the
recordsource query for your report. You then need to create a means (form
with controls and VBA) that the users will use to alter the QueryDef SQL.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@xxxxxxxxxxxxxxx
www.pcdatasheet.com


<ajspacemanspiff@xxxxxxxxx> wrote in message
news:1129317499.119928.264130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I currently have a solution that requires 2 sub queries, where each of
> them is convereted into a crosstab query and then I join the crosstab
> queries to a result. I would like to make this more dynamic and
> allow for users to filter, and to do so I would like to be able to
> create the resulting query all in VBA code.
>
> I can create a recordset of each inital query, but is there a way to
> run a query on that, and then subsequently, a query on that returned
> recordset.. so i may create the desired recordset for the report?
>


.

Relevant Pages

  • Re: Data Changing Issue
    ... In the query, on the field line, I added the above expression. ... *if* you are in VBA. ... the data of your table from a recordset. ... I am running some queries using a form I created and for some ...
    (microsoft.public.access.queries)
  • Re: Can I perform a DCount of records returned by SQL statement (not a saved query)
    ... a recordset has parameters that you aren't feeding to the query. ... you'll need create a temporary querydef that is based on ... Dim rst As Recordset ...
    (comp.databases.ms-access)
  • Re: QueryDef vs. Recordset Errors
    ... the query is probably not quite correct. ... You can open a recordset based on the QueryDef after you ... Dim qdf As QueryDef ...
    (microsoft.public.access.formscoding)
  • Re: How do I verify a valid sql statement programatically ??
    ... recordset, ASP, and javascript. ... the ASP session to minimize generating the query from the DB with different ... parts of the system that generated record lists would use the same list ... Many places in our system generate dynamic queries based on various ...
    (microsoft.public.sqlserver.programming)
  • Re: Programmatically running SQL Query
    ... To get the results of a query into a recordset and access them ... it can be done (I'm not strong in queries by any means). ... FROM PS RIGHT JOIN Verification ...
    (microsoft.public.access.modulesdaovba)