Re: Help.... Adding/ Sorting

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 00:53:04 -0600

If you want to group several records together, you should have a field that
contains the same value for those records. Actually Blue Stripe Sofa should
be three fields, FurnitureType, Color, Pattern. 

-- 
Duane Hookom
MS Access MVP
"Mojo" <Mojo.12boee@nospam.MSAccessForum.com> wrote in message
news:Mojo.12boee@nospam.MSAccessForum.com...
>
> Hey there,
>
> I was wondering if any of you could help me on how to run a query.
>
> Here is the table info...
>
>
> Item              /Model #         /Dollars in Feb.
>
> Blue sofa          /B1                /$10
> Green sofa         /C1                /$20
> Blue stripe sofa   /A3                /$20
> Purple sofa        /G2                /$5
>
> How do I run a query to add the blue sofa to the blue stripe sofa,
> total their dollars and then rank descending?
>
> The result I'm looking for is...
>
> Blue sofas  (both solid and striped)   then the models (B1 and A3) then
> total dollars in Feb...$30.
>
> Then rank the others beneath them in dollars.
>
> Help!!!
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>