Re: Custom query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 10:37:51 -0400

On my websites (see sig below) are several small sample databases all
starting with "CreateQueries". They illustrate (in ascending difficulty)
how to do allow your users the ability to create their own queries.
CreateQueries5 is the most flexible, but you might want to look at the
others first to get an idea of what is going on. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"jan" <anonymous@discussions.microsoft.com> wrote in message
news:b7b801c4891d$735e3ff0$a401280a@phx.gbl...
> I have created many pre-determined queries for users to
> run but would like to give the user the flexibility to
> create their own queries.  This would minimize the amount
> of pre-defined queries.  How can I set this up without
> having the user use the "query wizard"?
>
> Any help would be appreciated.
>
> Jan
>

Relevant Pages

  • Re: Question about a data structure
    ... entries, that's 150,000 records, and thinking about writing the queries to ... *millions* of detail table records with little performance degradation. ... flexibility. ...
    (alt.php)
  • Re: Capturing Max Value in Code
    ... (That is: Update Queries, ... Roger dot Carlson at Spectrum-Health dot Org ... > argument consisting of an SQL statement." ... Is this an odd way to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Queries wont let me type in them
    ... Queries can be made Non-Updateable in a number of ways. ... Making the query a Crosstab query ... Roger dot Carlson at Spectrum-Health dot Org ... "Isidore" wrote in message ...
    (microsoft.public.access.queries)
  • Re: Large array, slow calcualtion of formulas
    ... responding to queries. ... Do plough-in! ... flexibility that takes time to learn! ...
    (microsoft.public.excel.misc)
  • Custom query
    ... I have created many pre-determined queries for users to ... run but would like to give the user the flexibility to ... having the user use the "query wizard"? ...
    (microsoft.public.access.queries)