Advertisement

07.08.2008 at 08:07AM PDT, ID: 23546920
[x]
Attachment Details

VB SQL - Adding sums to existing Sum queries

Asked by andyb7901 in SQL Query Syntax, Microsoft Access Database

Hi,

I have a query which is filtering on quite a bit. I need it however to filter on a little more. I need it to filter now on the Sponsor field. I need to say once all filters have taken place, out of thos records which have a sponsor address of And@hotmail.com. I need to then take this figure away from my original figure

Sum(Abs(tbl_MIS_Records.[Account Type] In ("RegularAC","TopAC") And tbl_MIS_Records.Status In ("Approved","Not Approved","Mail Sent to requestor") And (tbl_MIS_Records.Location In ("Moscow","Istanbul") Or ([Location]="Johannesburg" And [LOB]="GCCG & Rates Derivatives")))) AS First_count,    -(minus)-     If any of these account have a tbl_MIS_Records.[Sponsor] in ("andy@hotmail.com").

Any ideas?Start Free Trial
 
Keywords: VB SQL - Adding sums to existing Su…
Title
1 Sum in a query
2 Derived column for frequency count
3 Union Sum problem
4 derived data
5 Subquery in VWD
6 reducing sum across rows
 
Loading Advertisement...
 
[+][-]07.08.2008 at 08:26AM PDT, ID: 21954732

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.

 
[+][-]07.08.2008 at 08:29AM PDT, ID: 21954759

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.

 
[+][-]07.08.2008 at 09:10AM PDT, ID: 21955234

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.

 
[+][-]07.08.2008 at 09:13AM PDT, ID: 21955265

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.

 
[+][-]07.08.2008 at 09:35AM PDT, ID: 21955506

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: SQL Query Syntax, Microsoft Access Database
Sign Up Now!
Solution Provided By: GRayL
Participating Experts: 2
Solution Grade: B
 
 
[+][-]07.09.2008 at 01:17AM PDT, ID: 21961445

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.

 
[+][-]07.09.2008 at 02:08AM PDT, ID: 21961650

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.

 
[+][-]07.09.2008 at 02:19AM PDT, ID: 21961695

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.

 
[+][-]07.09.2008 at 07:58AM PDT, ID: 21964350

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.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628