Results 1 to 4 of 4
  1. #1
    briang is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2016
    Posts
    2

    Adding instance of 2 bedrooms per location

    Hi.
    I'm taking a access class, Any help is appreciated!

    The Question is, How many two bedroom apartments are in each location.
    This query displays 6 rows showing each 2 bdrms, but I want to just have the location number in collum one, and how many 2 bed room apts are in each.

    Code:
    SELECT LocationNum, Bdrms
    FROM CondoUnit
    WHERE Bdrms=2;




  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Play with the Totals button on the ribbon. Looks like an "E", the Greek sigma.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    briang is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2016
    Posts
    2
    That did work! Now to examine what that did in the actual SQL! Thanks!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site by the way! Great way to learn, playing with queries in design view and then switching to SQL view to see the actual SQL.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Selecting hihest instance in a tbl
    By Ciaran in forum Queries
    Replies: 2
    Last Post: 08-01-2015, 10:59 PM
  2. Replies: 2
    Last Post: 07-14-2015, 11:39 AM
  3. Replies: 5
    Last Post: 10-11-2013, 07:29 AM
  4. Replies: 7
    Last Post: 02-01-2013, 02:58 PM
  5. Replies: 5
    Last Post: 09-14-2012, 04:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums