Hi,
I am wondering if it is possible to make a calculated field on a field in the same query. For example, say I have a products table with products and prices. Then I make a select query to pull all products with a price of zero. In that same query can I also count how many products there are with the price of zero. Or do I NEED to make a second query on top of the first to count all of the products listed in query 1.
This is a simple application, but there are many instances where I have wanted to do this, but always end up having to do two separate queries.
Any help is GREATLY appreciated!!
Thank you