[thechat] Microsoft Access 97 Query

[Syed Zeeshan Haider]

Hi Rudy,
Respectfully saying, I don't think this is the wrong list. I am learning
MS Access 97 without any teacher and my question is for learning
purpose. I think it is not directly related to web development.
Thank you for such a detailed reply. I'll try all this tomorrow morning
because it is too late here at night now.
Thanks again!
Syed Zeeshan Haider.
http://syedzeeshanhaider.faithweb.com/

----- Original Message -----
From: "rudy" <rudy937 at rogers.com>
To: "thechat" <thechat at lists.evolt.org>
Subject: [thechat] Microsoft Access 97 Query
Date: Wed, 5 Jun 2002 10:40:18 -0400
Reply-To: thechat at lists.evolt.org

> I have table containing listing some CD's and their prices.
> Now I want to create a query which could sum up the prices
> of those CD's and give the total amount.

hi syed

wrong list   ;o)

your answer below the anti-tip

<tip type="quatsch">
Jim Romenesko's Obscure Store and Reading Room
http://www.obscurestore.com/
</tip>

okay, syed, here's how to get the total prices of all the cds

   select sum(cdprice) from cdtable

if you want the total prices of only some of the cds

   select sum(cdprice) from cdtable
          where cdtype="country and western"

if you want the average price by type

   select cdtype, sum(cdprice) from cdtable
       group by cdtype

i could go on, but that should get you started

check the help file again under "aggregate functions"

or try a tutorial
here --http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials_main.asp

also, The Access Web (http://www.mvps.org/access/) is pretty good but
might
not be best to learn from

rudy
http://rudy.ca/