Query to average between two dates.

[stormchaser]

Hi, I'm new to access and now i have to make some project for school and I got to create a video archive, thats ok I did that but now here comes the hard part i have to make a query to show me the average days that a movie has been hold and a query that shows wich is the most popular actor..


what function should i use to do that? (p.s sorry for my bad english )

[DanB]

Try this:

SELECT AVG( [Date_OUT]-[Date_RETURN]) AS Average_Out
FROM [YOUR TABLE NAME HERE];

[stormchaser]

Yes i got this one now the only thing i got left to do is to determine the most wanted movie and actor wich function should i use?

[DanB]

This should get you started...

SELECT Title, Count(*) AS Popular
FROM [YOUR TABLE NAME HERE]
GROUP BY Title
ORDER BY Count(*) DESC;

[stormchaser]

yes i did it all thank you for your help and time