neomarvelbuuny
03-24-2008, 09:30 PM
i have several LPs for which i don't have track durations entered (they've either been manually entered and there were no durations listed, or i downloaded the track titles from Amazon instead of freeDB).
For maintenance purposes i'd like to create a query to list all of those, but i can't figure out how to set it up. i've tried to search in the "track duration" field for exactly 0:00, for less than 0:01, and for "track duration" is empty, both as an album and as a track search, but every time i get the "No records were found" message.
Is there a way that i can search for zero/null duration? It would save me A LOT of time.
For maintenance purposes i'd like to create a query to list all of those, but i can't figure out how to set it up. i've tried to search in the "track duration" field for exactly 0:00, for less than 0:01, and for "track duration" is empty, both as an album and as a track search, but every time i get the "No records were found" message.
Is there a way that i can search for zero/null duration? It would save me A LOT of time.