Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Query To account for all Cities in The Table

    Code:
    SELECT AbsorptionRate.City, AbsorptionRate.PropertySubType, AbsorptionRate.Status, Count(AbsorptionRate.Status) AS CountOfStatus
    FROM AbsorptionRate
    GROUP BY AbsorptionRate.City, AbsorptionRate.PropertySubType, AbsorptionRate.Status
    HAVING (((AbsorptionRate.City)=[Enter City Code]));
    This query works fine, however I would also like to bypass selecting specific cities and just have them all run at one time.

    Ideas . . . Rick

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    502
    OK I got it . . .

    I just deleted this . . . HAVING (((AbsorptionRate.City)=[Enter City Code]));

    All cities are run at one time.

    Thanks . . . Rick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •