Report or Query to show First & Last Date Item is rented

[mariaa]

I am trying to figure out how so calculate the number of times an item has
been rented as well as the first date it was rented and last date it was
rented.

Equipment # of Rentals First Date Rented Last Date Rented

What would be the best way to go about getting this data

 

[fredg]

I am trying to figure out how so calculate the number of times an item has
been rented as well as the first date it was rented and last date it was
rented.

Equipment # of Rentals First Date Rented Last Date Rented

What would be the best way to go about getting this data

Create a query to use as the report's recordsource.

SELECT YourTable.Equipment, Count(YourTable.Equipment) as
NumOfRentals, Min(YourTable.RentDate) AS FirstRented,
Max(YourTable.RendDate) AS LastRented
FROM YourTable
GROUP BY YourTable.Equipment;

 

[mariaa]

WOW. That is perfect and so simple. Thank you.

Create a query to use as the report's recordsource.

SELECT YourTable.Equipment, Count(YourTable.Equipment) as
NumOfRentals, Min(YourTable.RentDate) AS FirstRented,
Max(YourTable.RendDate) AS LastRented
FROM YourTable
GROUP BY YourTable.Equipment;