Help.... Adding/ Sorting

  • Thread starter Thread starter Mojo
  • Start date Start date
M

Mojo

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) the
total dollars in Feb...$30.

Then rank the others beneath them in dollars.

Help!!
 
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.
 
When using a relational data base you should try to
catagorize information into common unique attributes
(color, style, size, covering, model number, UPC, etc.)
and individual atributes that uniquely identify (Serial
number, Order number, etc.. the individual records (rows)
that make up the tables or information you are trying to
organize. Sometimes information, like your couch
inventory does not require unique identifiers, i.e.
couches generally don't have serial numbers. in this case
the Database software (Access) will assign a set of
sequential number to each record as they are entered.

You should considering redesigning your database with some
of the following fields:
Product Type : 1 = Couch, 2 = Chair,..., 95 = Umbrella
stand (THIS SHOULD BE AN INDEX)
Primary Color: Blue, Brown, Dark green, etc...)
Secondary Color: " " " " "
Covering pattern: Stripped, Solid colot, Checked, Plaid,
etc..)
Material type: Nylon, Leather, Cotton, etc..)
Price
Cost
Day entered into inventory
Etc...

This means when you enter the data you must describe each
piece of furniture with specific standard attributes you
have set up (above).

When you have the data broken down into separate like this
it is easy to select, sort, sum and report on the
attributes you desire. In your case you seem to want to
work with couches that have blue in their coloring.

By breaking the data down queries become easy to write. If
your doing this for a business you might want to hire a
professional.

Good luck,
Hunter

determine the embedded >-----Original Message-----
 
Hey there.

THANK YOU VERY MUCH FOR ALL YOUR HELP!!!!

Here is where I'm at now.

I created a master file in order to assign a "special code" to eac
sofa. I ran a query between 2 sheets and ended up with this....

Blue sofa /B1 /$10/ Blue sofas
Green sofa /C1 /$20/ Green sofas
Blue stripe sofa /A3 /$20/ Blue sofas
Purple sofa /G2 /$5/ Purple sofas
Click to expand...


This way I have all blue sofas with an identifier term column assigne
to them.

Now.....

How do I modify the query to add all the dollar ammounts in all item
that have a "Blue sofas" code and then compare and rank descending vs
the others.

Ultimately this is what I want to end up with .....


Blue Sofas $30
Green Sofas $20
Purple Sofas $5

I'm thinking I run a second query? But how do I tell it to add th
dollar figures related to a particular name (Blue sofas).

All the help is greatly appreciated!!!!

Jo
 
Hey there.

THANK YOU VERY MUCH FOR ALL YOUR HELP!!!!

Here is where I'm at now.

I created a master file in order to assign a "special code" to each
sofa. I ran a query between 2 sheets and ended up with this....

Blue sofa /B1 /$10/ Blue sofas
Green sofa /C1 /$20/ Green sofas
Blue stripe sofa /A3 /$20/ Blue sofas
Purple sofa /G2 /$5/ Purple sofas
Click to expand...


This way I have all blue sofas with an identifier term column assigned
to them.

Now.....

How do I modify the query to add all the dollar ammounts in all items
that have a "Blue sofas" code and then compare and rank descending vs.
the others.

Ultimately this is what I want to end up with .....


Blue Sofas $30
Green Sofas $20
Purple Sofas $5

I'm thinking I run a second query? But how do I tell it to add the
dollar figures related to a particular name (Blue sofas).

All the help is greatly appreciated!!!!

Joe
 
Create a totals query that groups by the SpecialCode field and totals the
currency field.
 
I'm sorry.....I've looked everywhere on how to do that and I can'
figure it out.

Can anyone post what that would look like
 
I'm sorry.....I've looked everywhere on how to do that and I can'
figure it out.

Can anyone post what that would look like
 
To create a totals query, click on the sigma button on the button bar or
select View|Totals.
 
Back
Top