Jun 27 2008, 01:18 PM
My apologies if this particular post is redundant, Iíve searched for similar ones with no luck.
My problem is fairly simple. Iíve got a Real Estate DB consisting of 2 tables: an Agents Table (Agent ID Primary Key) and additional Agent Info. Iíve also got a Properties Table consisting of the (Property ID Primary Key) and the Agent ID as a foreign key) along with related property characteristics including the Selling Price. Both tables have been joined through the Agents ID.
Iíve been attempting to Count the number of properties with a Selling Price in excess of $250000. Iíve used the >250000 on the criteria line for the Selling Price field and have applied the ďCountĒ feature to the PID and the Selling Price both separately and together to no avail. Any assistance would be most appreciated. Thanks!
Jun 27 2008, 01:29 PM
Your query will allow you to use the >25000 to filter the records required
To actually Count the nr of records you will need to Create a Report based on the Query and then use the Count Function
Hope this helps
Jun 27 2008, 01:50 PM
To continue with Mike's reply, the COUNT query should be very straight forward and easy. If as you say it is not working, then maybe there are a couple of things to look at.
First (to keep it simple) create a query with 2 fields in it
PropertyID, Selling Price (I assume selling price is a Currency field...? If not then it needs to be.)
The SQL will look like this
SELECT Count([tblProperty].PropertyID) AS CountOfPropertyID
WHERE ((([tblProperty].[Selling Price])>250000));
This SQL will return the correct count.
Jun 27 2008, 02:44 PM
It worked like a "charm".Thanks again.
Jun 27 2008, 03:02 PM
Glad to help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here