Re: how do I display data related to a top 10 query in access?

crimminsky wrote:
> "Rick Brandt" wrote:
>
> > My understanding is that the "top" in a TOP query is determined by
> > the fields you sort on. If you add additional fields, just don't
> > sort on them and they shouldn't affect the rows returned.
> >
>
> Hi Rick, thanks for the reply, I am only sorting the count of meal
> type column. this gives me,ie meat, 23, male
> fruit,13,female
> etc,etc
> What happens when i add the contents column(unsorted) is this
> meat,5,male,pork
> fruit,5,female,apples
> What I want is:-
> meat,23,male,pork
> meat,23,male,pork x5 etc etc
> listing all the 23 different meats, does this make any sense??

Then feed an initial query that gives you the TOP that you want into a second
query that adds the additional fields.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Make Table Query - Sorting Errors
    ... Dim OutputTable As DAO.Recordset ... The query to concatenate the CAMPNO values will need to be LOOKING at the ... If you post the query you are using to do this, I beleive we can get it to ... Is there a command that I can use in the module code to first sort the ...
    (microsoft.public.access.queries)
  • Re: Make Table Query - Sorting Errors
    ... You sort in a query, ... You can do a compound sort in a query. ... "Tom Ellison" wrote: ... resulting table only has one record for each value of "CAMPNO". ...
    (microsoft.public.access.queries)
  • Re: Query doesnt always sort
    ... You have to use a query to sort the data in to your required order and then ... Access MVP 2002-2005, 2007 ... University of Maryland Baltimore County ... How do I impose a sort on the datasheet view? ...
    (microsoft.public.access.queries)
  • Re: Make Table Query - Sorting Errors
    ... sorted, it will sort them as they arrive. ... you query them, why is this of any concern to you? ... correctly on the field CAMPNO. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)
  • Re: Make Table Query - Sorting Errors
    ... MS Access MVP ... resulting table only has one record for each value of "CAMPNO". ... Is there a command that I can use in the module code to first sort the ... I have a make table query that is supposed to sort in ascending order ...
    (microsoft.public.access.queries)