Recent content by lefe0102

Thanks! I may have forgot to say that this must be for a specific Item so I would have to leave it as SELECT TOP 1 tPrice.Price, Count(tPrice.Price) AS CountOfPrice FROM tPrice Where Item = @Item GROUP BY tPrice.Price ORDER BY tPrice.Price; Cheers!

Hi Guys... I am new to Microsoft Access and am primarily using the database that talks to an SQL database that I am using in a C#/ASP environment. Currently I am trying to create a query that would find the minimum price in a table however, I also want to count the amount of times that the...