Search results
-
R
A query that returns values that total less than a required amount?
I don't want find the records where the length is less than 900, sorry, but what i need is for the query to calculate when any of the records from the length field equal or are less than 900 in total. I hope that makes sense? So if three songs each with a song length of 300 seconds, once the... -
R
A query that returns values that total less than a required amount?
Hi Can anyone suggest a method for doing what the title asks. I basically have a single table with several fields. One of the fields is the length of music tracks in seconds. What i want to do is to set criteria so that when a query is run the records to not add up to more than 900 seconds...