Re: Step through each field in query
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
On Tue, 17 Apr 2007 03:34:01 -0700, twisty1980
<twisty1980@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have this sql query designed to show the top 10 records in a given field.
But I want to modify it so that I can use this one query to step through each
of the given fields and append them to the final report as opposed to having
to create a seperate query for each field.
A Crosstab query may be the solution here. Have you tried one?
John W. Vinson [MVP]
.
Relevant Pages
- Re: Programmatically changing the field formats for a table
... You can modify some properties of a field with SQL statements, ... Roger dot Carlson at Spectrum-Health dot Org ... > created using a query. ... > the resulting table does not keep the field formats of the ...
(microsoft.public.access.tablesdbdesign) - Re: webbased search through catalog
... I've got the asp script working, but it seems to spit out results ... Modify q.catalog to specify your catalog name. ... > ' your logo is not a GIF file, or you don't want to copy it, change the ... > ' You can set the number of query results returned on a single page ...
(microsoft.public.inetserver.indexserver) - Re: Help Combining Two Queries...
... first time you run the first query, it'll have to be a create table query; ... you'll want to change it to an append query) that holds ... Then you can modify the upper query to query the table, ... Of course, every time the queries run, you'll want to wipe out the previous ...
(microsoft.public.access.queries) - Re: Changing query at runtime
... Thanks Joan, I already tried that, but after giving the qtemp object Read ... Design, Modify Design and even Admin permissions, I still get the "You do ... option" clause in the query. ... and give users modify permissions to the query. ...
(microsoft.public.access.security) - Re: Albert D. Kallal -WordMerge20
... So I'd like the user to select the query from the ... date and the chosen WordMerge template. ... therefore DateParam (my user input form won't open). ... I'm wondering if there is a way to modify your WhatQuery form to accept user ...
(microsoft.public.access.queries) |
|
