Access 2007 Summarize 2 values from subqueries and display in the main Select statemt

[roeslein]

Hi Folks,



I am looking for a solution for the following problem.
I have one table whre I like to summarize 2 values created wit different criterias.
I tryed to create a main Sleect statement with 2 subqueries, but Iit will not work.
The subqueries as alone Select statements working fine, here the two select commands:
SELECT
Count(tblRaw_Data.[Contact last Name]) AS ['Count']
FROM tblRaw_Data
WHERE ((tblRaw_Data.Title<>"ESPI" And tblRaw_Data.Title<>"ESPB")) and tblRaw_Data.[Account Area] = "Europe/Middle East/Africa"
HAVING (Not tblRaw_Data.[Owner Last Name] =" ") AND (tblRaw_Data.Month=Left(MonthName(Month(Date())-1),3))

SELECT
Count(tblRaw_Data.[Contact last Name]) AS ['Count']
FROM tblRaw_Data
WHERE ((tblRaw_Data.Title="ESPI" Or tblRaw_Data.Title="ESPB") And tblRaw_Data.[Added Category]="FSSS" and tblRaw_Data.[Account Area] = "Europe/Middle East/Africa"
HAVING ( Not tblRaw_Data.[Owner Last Name]= " ") AND (tblRaw_Data.Month=Left(MonthName(Month(Date())-1),3))

If you can give me a hint, that should be great.
Have a great weekend!!!

[June7]

Do not use apostrophes in defining the alias Count fieldname. Actually, Count is a reserved word. Better name would be CountRaw.

You show a space as criteria for the OwnerLastName. Do you really want an empty string or Is Null as criteria? Will this field allowed to have space or empty string? I never allow empty string in tables.

You show two queries but not the main with 2 subqueries. Why doesn't the 'main' work - error message, wrong results, nothing happens?

Each of these queries will output only one record with one field. Seems the 'main' would simply be: SELECT Query1.CountRaw, Query2.CountRaw;