Search results for query: *

Dude, I absolutely love you. Works perfectly. I've slightly modified it so that one query requires the user to type the Video ID they want, and another so that it shows all of them. Thank you again

PHV, you are a GENIUS! It works perfectly. Thank you so much. Just to be cheeky now, is there any way I can get it to round up? If you can't be bothered to do it, don't worry. It's not essential, just would be easier on the eyes than a string of numbers. Anyways, thank you!

I think you've hit the nail on the head! I've just tried it out for one of them, and I'm given a sensible answer. I'm now going to check for the other films, and see if the value given is correct. Thank you so much for spending time on this. You're a god send and have probably saved my project!

Getting closer. No error messages (hurrah!), but Percentage Recovery is blank (boo :( )

None of them work. I just get told that the specified expression (sum(tblRental!Cost...........you know the rest) is not part of an aggregate function

Thanks for the very quick replies. Unfortunately I haven't got any working yet. Here is what I had originally (attempt 2) as SQL view: SELECT tblVideo.[Video ID], tblVideo.Title, (Sum(tblRental!Cost)+Sum(tblRental!Fines))/tblVideo!Cost*100 AS [Percentage Recovery] FROM tblVideo INNER JOIN...

Hey, I'm a noob on the forum so please bare with me. For my ICT project, I have to create a new system for a company. I am doing a Video Rental Database. My user wants to be able to work out the Percentage Recovery on a film, so that he knows how much he has made. The equation for this would be...