Re: how do I display data related to a top 10 query in access?
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Sun, 23 Oct 2005 17:34:01 GMT
crimminsky wrote:
> Hello, I am trying to run a query on a table that returns the top 10
> of a field. i.e
> The table contains 3 columns, meal type(meat,veg,fruit,cereal). male
> or female. meal contents
> (pork,lamb,chicken,potatoes,carrots,bananas,apples,weetabix,cornflakes
> etc)
>
> I can run the query so that it puts the top ten meal types in
> descending order and show me the count and whether it was a male or
> female that chose it. ie:- Meat,23,male. when i add
> the meal contents to the query, It sorts it in to top ten for the
> contents. I don't want that to happen. I want to be able to
> display on a report what each of those 23 meats were ie 10
> pork,10,lamb,3,chicken. Any ideas?
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.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
.
- Prev by Date: Re: Using Agregate "Count" to return 0 for Null values
- Next by Date: Re: IIF Function
- Previous by thread: Re: Using Agregate "Count" to return 0 for Null values
- Next by thread: Re: how do I display data related to a top 10 query in access?
- Index(es):
Relevant Pages
|
|
