not so simple tast for a query -- help

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

I have a table that looks a lot like the following:

Orgnization |Location Code | Equip ID | Supply ID | Supply
Weight | Usage Rate

Each organization type (organization) can operate in one
of two locations (Location Code). Each organization also
uses several items of equipment (Equip ID) and each item
of equipment uses one or more expendable supplies (supply
ID) which have weights and are used at different rates
based on location (Usage Rate).

I need to build a query that tells me how much weight is
allocated to each organization by location --- and I
haven't the foggiest idea on where to start.

Please -- if anyone has a suggestion/solution, I would
appreciate it.

Thanks,
JR
 
Hi JR

if i'm understanding you correctly then create a select query with the
following fields

Organization | Location Code | Weight

then click on the total icon (E) on the toolbar in design view of the query
change the group by to SUM under weight (leave the other two as group by)
sort Organization - ascending
sort Location Code - ascending

and you should have the information that you want

Regards
JulieD
 
Hi JulieD

It worked like a charm!

Thanks!
-----Original Message-----
Hi JR

if i'm understanding you correctly then create a select query with the
following fields

Organization | Location Code | Weight

then click on the total icon (E) on the toolbar in design view of the query
change the group by to SUM under weight (leave the other two as group by)
sort Organization - ascending
sort Location Code - ascending

and you should have the information that you want

Regards
JulieD




.
Click to expand...
 
Back
Top