Results 1 to 2 of 2
  1. 01-31-2015, 03:26 PM #1
    alibanks
    alibanks is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    Crosstab with sum and count function?

    I have data where I want the following



    Col Heading 0-10000 100001-250000 250001-500000 500001 - 1000000
    Row Heading (Fin Year)
    2010
    2011


    2012
    2013
    2014


    at each point I would like to calculate the number of projects and the value of projects.

    I can do this on two separate queries. Is it possible to have it as one?
    Reply With Quote Reply With Quote
  2. 01-31-2015, 09:25 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Review http://allenbrowne.com/ser-67.html#MultipleValues
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. CrossTab query Count() doesn't match.
    By elena in forum Queries
    Replies: 5
    Last Post: 05-13-2014, 12:24 PM
  2. How to count multiple field values in a crosstab query
    By Swatskeb in forum Queries
    Replies: 7
    Last Post: 04-28-2014, 07:09 AM
  3. COUNT Group Count Records COUNT FUNCTION
    By PMCOFFEY in forum Access
    Replies: 9
    Last Post: 11-09-2012, 09:40 PM
  4. count blank colums in crosstab query
    By survivo01 in forum Queries
    Replies: 6
    Last Post: 04-13-2012, 01:37 PM
  5. Crosstab Count query - show all rows+columns
    By teedee in forum Queries
    Replies: 1
    Last Post: 01-24-2011, 03:03 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums