RE: Count based on criteria

Post the SQL of query1.
--
KARL DEWEY
Build a little - Test a little


"Cecilia" wrote:

I have the following query with the following:

Query 1 has the following records:
Item
Store No.
Ships
OnHand

ony records selected are those with ships >0

I'm trying to create another query from Query 1
that lists the following:

Items
OnHand (count stores >2)
OnHand (count stores >3)

Stores should not be displayed and I don't want to display values >2 or >3
just the total count of stores that meet that criteria.

Any ideas???


.

Relevant Pages

  • Re: other table that stores data differently than ADO.Net datatable?
    ... query the database everytime the user does a scroll ... will display the next N records once the user has reached the last visible ... > We have this huge application that's based on storing tons of data on a ... > datatable that stores a better way. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: other table that stores data differently than ADO.Net datatable?
    ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ... >>>> We have this huge application that's based on storing tons of data on ... >>>> datatable that stores a better way. ...
    (microsoft.public.dotnet.languages.csharp)
  • Opening a form to the correct record (VBA)
    ... The first combobox gets it's values from a table and stores the ID of the ... The second combobox gets it's values from a table and stores the ID of the ... I create a simple Append Query to add a record into my evaluation table ...
    (microsoft.public.office.developer.vba)
  • Re: Opening a form to the correct record (VBA)
    ... The first combobox gets it's values from a table and stores the ID of ... The second combobox gets it's values from a table and stores the ID of ... I create a simple Append Query to add a record into my evaluation table ...
    (microsoft.public.office.developer.vba)
  • Re: Count based on criteria
    ... That assumes that query1 has no duplicated couple ... Query 1 has the following records: ... OnHand (count stores>2) ...
    (microsoft.public.access.queries)