Advertisement

01.08.2008 at 07:08AM PST, ID: 23066600
[x]
Attachment Details

Calculating total on a query

Asked by gfranco in Access Coding/Macros, SQL Query Syntax

Tags: calculate, query, total

Hi I need to have a query based on a formula % of CSCC/(IQT+SCC+CSCC)

But I only got this total on my query and I need to know how can I show this result

Month   % Adoption
-------- ---------------
Jan             50%
Feb             30%
and so on

But Only I got this on my query, i need to modify it for getting the resul above.

Created By Source      Total Quotes Created
CSCC                               773
IQT                               5785
SCC                              10185Start Free Trial 
1:
2:
3:
4:

SELECT QuotesFile.[Created By Source], Count(QuotesFile.[Created By Source]) AS [Total Quotes Created]
FROM QuotesFile
WHERE (((QuotesFile.[Created By Source]) In ('IQT','CSCC','SCC')) AND (([QuotesFile].[Creation  Date]) Between '11/1/2007' And '11/30/2007'))
GROUP BY QuotesFile.[Created By Source];
[+][-]01.08.2008 at 07:23AM PST, ID: 20609280

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.08.2008 at 07:39AM PST, ID: 20609413

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.08.2008 at 07:52PM PST, ID: 20615391

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.08.2008 at 10:28PM PST, ID: 20615954

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 11:58AM PST, ID: 20621707

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.09.2008 at 11:16PM PST, ID: 20625488

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 09:57AM PST, ID: 20629342

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 10:02AM PST, ID: 20629390

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.10.2008 at 10:17AM PST, ID: 20629524

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, SQL Query Syntax
Tags: calculate, query, total
Sign Up Now!
Solution Provided By: TextReport
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628