473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Help needed again

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
2 1105
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
Thank you, it works

May 12 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: netpurpose | last post by:
I need to extract data from this table to find the lowest prices of each product as of today. The product will be listed/grouped by the name only, discarding the product code - I use...
8
by: slim | last post by:
hi again all, i am still working on the website as mentioned in earlier threads and have hit another snag... http://awash.demon.co.uk/index.php http://awash.demon.co.uk/vd.css the php is...
6
by: Jax | last post by:
I have Visual Studio 2002 Standard Edition. It has been working fine up to a point and now i'm at that point. Due to the limitations of the edition i am not using any of my own .dll's and instead...
8
by: intrepid_dw | last post by:
Hello, all. I've created a C# dll that contains, among other things, two functions dealing with byte arrays. The first is a function that returns a byte array, and the other is intended to...
5
by: Andrew | last post by:
Hey all, Requesting help from the VB.Net gurus in here. I was given a task to write a Windows Service (VB.Net) that would run an external program, and if that program closed for any reason...
4
by: Gary | last post by:
Hi, I have a temperature conversion program down pat, but I was told to add an average, meaning, i need to get the average temperature for as many times as it was entered. i do not know where to...
2
by: Steve K | last post by:
I got a bit of a problem I like some help on. I'm designing an online training module for people that work in food processing plants. This is my target audience. These workers have little or no...
15
by: Jay | last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second interval. Basically, I look in a SQL table (queue) to...
14
namcintosh
by: namcintosh | last post by:
Hello, everyone. Well, let me cut to the chase and explain my problem. I am trying to devise a menu plan that uses the if/else if and the while loop. The program calculates the user's weight...
32
by: =?Utf-8?B?U2l2?= | last post by:
I have a form that I programmatically generate some check boxes and labels on. Later on when I want to draw the form with different data I want to clear the previously created items and then put...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.