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

  • Thread starter Thread starter mariaa
  • Start date Start date
M

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
 
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
Click to expand...

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;
 
WOW. That is perfect and so simple. Thank you.

fredg said:
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;
Click to expand...
 
Back
Top