Re: Total

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Please be more specific. What are you trying to total - none of the fields
you have shown have numbers.

>From the sample data you have given what result set are you expecting from
the query?

"JLS" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:036001c53914$95d831b0$a501280a@xxxxxxxxxx
>I was wondering if i have a table and in the first column
> is the category which the product would fall under in the
> second column is the names of product... How could I get a
> total for the second column for each of the distinct
> categorys in the first with out querying for each distinct
> category name.
>
> Category Name Product Type
> Safety Eye Glasses
> Safety Helmet
> Chemicals Acids
>
> I want the total products for each of the distinct
> Catgoreis. Please Help!


.

Relevant Pages

  • RE: Printing wide columns
    ... > I have a spreadsheet that I want to print. ... but the second column is very wide. ... > able to print the first column. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Memory Error while constructing Compound Dictionary
    ... > For the purpose of illustration let's suppose that the first column ... suppose the second column contains a ... this is a prelude to complicated meta-hack programming of the type Python ... in which case you either need a larger machine or a database. ...
    (comp.lang.python)
  • Re: Sorting two columns of data
    ... you can record a small macro to cut the second column ... and paste it to the bottom of the first column, then select it and sort, ... > My intent was to be able to import data from a database and have the sort ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Fill Text Caption with Value
    ... which will display Bob when a new record is entered. ... Value is 'Bob' and not the '2'. ... I would like to show the second column ... the first column, ...
    (microsoft.public.access.formscoding)
  • Re: The Psi Divide
    ... only read "Weyr Search" in that series), much of James Schmitz, ... I have trouble with the second column, ... were plenty of Galaxy and Analog short stories that had ... First column, I think. ...
    (rec.arts.sf.written)