Viewing a Query

  • Thread starter Thread starter Dave Ruhl
  • Start date Start date
D

Dave Ruhl

In Visual FoxPro the Browse command allows you to view a
table, query, or SQL Select statement in a datasheet
format. I know the docmd.opentable and openquery work
the same for tables and queries, but is there a way in
Access 2002 to view the results of a SQL Select
statement ? In testing SQL, it would be helpful to be
able to view my results 'on the fly'.
 
Probably a work-around is to create a saved Query "qselForDisplay". When
you want to display the result selt of the SQLString, use the DAO QueryDef
Object to modify the SQL String of "qselForDisplay" and then use the
DoCmd.OpenQuery on "qselForDisplay".

HTH
Van T. Dinh
MVP (Access)
 
Back
Top