I'm working with a query and have the following three data fields - color, country and weight.
I have selected a range criteria for weight of between 5 and 10 lbs. I can get the query to display that criteria (only the entries between 5 and 10 lbs) but I want to have another field that simply displays the total number of found records within that criteria.
For example, the query returns 7 items between 5 and 10 pounds but shows them individually. How do I create a field in the query that just shows the total number of found records (7)? Can this be done?
-Jason
I have selected a range criteria for weight of between 5 and 10 lbs. I can get the query to display that criteria (only the entries between 5 and 10 lbs) but I want to have another field that simply displays the total number of found records within that criteria.
For example, the query returns 7 items between 5 and 10 pounds but shows them individually. How do I create a field in the query that just shows the total number of found records (7)? Can this be done?
-Jason