Query appears to ask 2 unrelated questions ? ? ?

[Rick4077]

That's the error that I get when attempting to run this query.

..SFR..  | 2006-08.., calc count all, AS "SFR New Listings" |
..CONDO..| 2006-08.., calc count all, AS "CONDO New Listings" |

I never could figure out how to calculate same fields in the same table using different selection critiera. In this case ..SFR.. and ..CONDO..

Thanks. Rick

 

[Miros]

I've had problems with this too. You need to make sure the results will be exactly the same, same name, same data type, same length (if it's a string).

In your example, your calculated fields do not have the same name, causing Paradox to see it as two separate queries.

You might be able to use a separate table with the date and calculated fields for the two types of New Listings.

Otherwise, you need to run two separate queries. You might be able to set up a form or report with both queries on it, but I've had varying levels of success with that.

 

[Rick4077]

Miros . . . if the results have the same name, then how can I determine which isi which?

Thanks . . . Rick

 

[Miros]

Try:

..SFR..  | 2006-08.., calc count all, AS "New Listings" | calc "SFR  ", as "Type" |
..CONDO..| 2006-08.., calc count all, AS "New Listings" | calc "Condo", as "Type" |

This should give you two records with two fields each, "Type" and "New Listings"; note that there are two spaces after SFR so it has the same number of characters as Condo.