querydef

[actros]

i am new in msaccess

can explane sameone where a querydef stored ;;

and an example who can i made a querydef to count samethik in a table

and then to look in this querydef the results ....

please a simle sample .....

 

[John Vinson]

i am new in msaccess

can explane sameone where a querydef stored ;;

and an example who can i made a querydef to count samethik in a table

and then to look in this querydef the results ....

please a simle sample .....

Where the querydef is stored, internally in the database, is sort of
irrrelevant; Microsoft hasn't published or disclosed the internal
structure of the .mdb file.

You can use a saved Query in the Query window; in VBA, you can use the
DAO Querydefs collection to retrieve a query. In order to view the
results of a select Query, you can simply doubleclick on its name in
the query window, or use the OpenQuerydef method in either a Macro or
VBA, or (best) base a Form or Report on the query.

John W. Vinson[MVP]