UNION Query Wants Parameter Value Entered?

[sharkchaser]

This is what I have. . .

It keeps asking me to enter an 'Active' parameter value?

SELECT COUNT(*) AS [Count <=199999]
  FROM tblCARETSData
 WHERE ListingStatus = ‘Active’
   AND ListPrice <= 199999
   AND County = 'orange'

UNION ALL

SELECT COUNT(*) AS [Count >=200000 <=299999]
  FROM tblCARETSData
 WHERE ListingStatus = ‘Active’ 
   AND ListPrice >=200000
   AND ListPrice <=299999
   AND County = 'orange';

Any suggestions would be greatly appreciated.

Thanks . . . Rick

 

[dhookom]

I would copy the SQL and paste into a new, blank query. You might also use " rather than '.

Duane
Hook'D on Access
MS Access MVP

 

[Hap007]

Hi Rick,

You need to revise both of your 'Where' Statements

ie:
WHERE
( ((tblCARETSData.ListingStatus) = 'Active') AND
((tblCARETSData.ListPrice) <= 199999) AND
((tblCARETSData.County) = 'orange') )

Make the same type of change to the both where statements in the union query.

Hope this helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[SkipVought]

SELECT
  COUNT(*) [b]AS Cnt
, 'Count <=199999' AS 'Range'[/b]
  FROM tblCARETSData
 WHERE ListingStatus = 'Active'
   AND ListPrice <= 199999
   AND County = 'orange'

UNION ALL

SELECT 
  COUNT(*)[b]
, 'Count >=200000 <=299999'[/b]
  FROM tblCARETSData
 WHERE ListingStatus = 'Active' 
   AND ListPrice >=200000
   AND ListPrice <=299999
   AND County = 'orange';

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]