By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Help needed again

P: n/a
Hi, i need your help again. I know my problems are v. easy for you, but
i'm beginner in access and need a solution.

I have a table like this (there is only one record for each product,
but one or more record for each average quality, there are also two
warehouses: #1 and #0).

Product Average Warehouse
name Quality
A 1.5 1
B 2 0
C 1.5 1
D 0.4 1
E 2 1
I need to calculate how many records for each average quality are in
the table (here i have 2 records for avg quality 1.5 and 2, and one
record for 0.4) and how many products of that quality are located in
warehouse #1 (here all products of avg quality 1.5 are stored in
warehouse #1).

So in this example:

Average Warehouse1
Quality
1.5 100% (2 of 2)
2 50% (1 of 2)
0.4 100% (1 of 1)

thanks for help
Lebo

May 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
DFS
Lebowski wrote:
Hi, i need your help again. I know my problems are v. easy for you,
but i'm beginner in access and need a solution.

I have a table like this (there is only one record for each product,
but one or more record for each average quality, there are also two
warehouses: #1 and #0).

Product Average Warehouse
name Quality
A 1.5 1
B 2 0
C 1.5 1
D 0.4 1
E 2 1
I need to calculate how many records for each average quality are in
the table (here i have 2 records for avg quality 1.5 and 2, and one
record for 0.4)
SELECT [Avg Quality], Count([Avg Quality]) as Count
FROM Table;
and how many products of that quality are located in
warehouse #1 (here all products of avg quality 1.5 are stored in
warehouse #1).

So in this example:

Average Warehouse1
Quality
1.5 100% (2 of 2)
2 50% (1 of 2)
0.4 100% (1 of 1)

SELECT [Avg Quality], Count([Avg Quality]) as Warehouse1
FROM Table
WHERE Warehouse = 1;

That query won't give you percents or 'm of n' results, though.


thanks for help
Lebo

May 12 '06 #2

P: n/a
Thank you, it works

May 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.