Hello I am working with an ms access 97 database and Table1 has two columns called ListPrice and CostPrice. Is there a way to return a recordset that only two rows with 2 columns, the columns would be "Field Name" and "Count". The "Field Name" would be ListPrice and CostPrice and "Count" would count how many times that field name had a higher price than the other. For example:

TABLE:
CostPrice ListPrice
2.95 1.95
3.95 5.95
.95 1.95

Returned Recordset:
CostPrice 1
ListPrice 2

Is that possible?

Thanks,
Thai