Results 1 to 5 of 5
  1. 05-25-2011, 02:24 PM #1
    efleming
    efleming is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    May 2011
    Location
    Ontario, Canada
    Posts
    11

    Cool Question; Count function ..

    LoL ...!! LoL ...!! LL ...!! LoL ...!!LoL ...!! ...soLveD by CaPtaIN DaTaBaSE ...!!
    Last edited by efleming; 06-01-2011 at 10:12 AM.
    Reply With Quote Reply With Quote
  2. 05-26-2011, 01:50 AM #2
    Rixxe
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    http://www.techonthenet.com/sql/count.php
    http://www.techonthenet.com/sql/sum.php

    Those should help you decide what you need. Honestly it takes two seconds to google the answers to those questions.
    Reply With Quote Reply With Quote
  3. 05-26-2011, 08:20 AM #3
    efleming
    efleming is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    May 2011
    Location
    Ontario, Canada
    Posts
    11
    LoL ...!! LoL ...!! LL ...!! LoL ...!!LoL ...!! ...soLveD by CaPtaIN DaTaBaSE ...!!
    Last edited by efleming; 06-01-2011 at 10:12 AM.
    Reply With Quote Reply With Quote
  4. 05-27-2011, 05:59 AM #4
    Rixxe
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    In that case this might be more useful:

    http://office.microsoft.com/en-us/ac...010096311.aspx

    Fine, it might require a bit of looking, but all the information is there. If there however is a specific problem with your query that you are trying to figure out, then sure ask here.
    Most functions such as COUNT() and SUM(), while displayed using SQL code still tell you what the functions DO. (This is what you were asking)

    Good Luck
    Reply With Quote Reply With Quote
  5. 05-27-2011, 08:05 AM #5
    efleming
    efleming is offline Novice
    Windows 7 32bit Access 2002
    Join Date
    May 2011
    Location
    Ontario, Canada
    Posts
    11
    LoL ...!! LoL ...!! LL ...!! LoL ...!!LoL ...!! ...soLveD by CaPtaIN DaTaBaSE ...!!
    Last edited by efleming; 06-01-2011 at 10:12 AM.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. count and switch function in same select query
    By sandlucky in forum Queries
    Replies: 2
    Last Post: 04-08-2011, 11:16 PM
  2. Access function to count records
    By mbaptista1970 in forum Access
    Replies: 6
    Last Post: 01-07-2011, 09:50 AM
  3. Count function on query
    By yousillygoose in forum Queries
    Replies: 1
    Last Post: 02-15-2010, 09:58 PM
  4. Count function in Query always Read Only?
    By terbs in forum Queries
    Replies: 3
    Last Post: 01-19-2010, 05:43 PM
  5. Query using count function
    By wasim_sono in forum Queries
    Replies: 0
    Last Post: 11-28-2007, 03:16 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums